---------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/nravanilla/Downloads/HRS_JOP2_Replication/1_Code/bureaucrat_q
> uality_logfile.log
  log type:  text
 opened on:   1 Oct 2024, 19:22:24

. 
. ***************
. * Main Tables *
. ***************
. 
. 
. ************
. * Table A1 *
. ************
. 
. cd "~/Downloads/HRS_JOP2_Replication/2_Data"
/Users/nravanilla/Downloads/HRS_JOP2_Replication/2_Data

. 
. use "Officer-Level Data.dta",clear

. 
. 
. // Assign labels to traits raw scores
. label variable psm "Public Service Motivation"

. label variable ds "Cognitive Ability (Digit Span Score)"

. label variable grit "Grit Scale"

. label variable bfi "Big 5 Personality Index"

. label variable extroversion "Extraversion"

. label variable agreeable "Agreeableness"

. label variable conscientious "Conscientiousness"

. label variable neuroticism "Neuroticism"

. label variable openness "Openness"

. 
. // Assign labels to independent variables
. label variable psm_z_wmiss "Public Service Motivation"

. label variable ds_z_wmiss "Cognitive Ability (Digit Span Score)"

. label variable grit_z_wmiss "Grit Scale"

. label variable bfi_z_wmiss "Big 5 Personality Index"

. 
. //Assign labels to officer-level controls
. label variable female "Female"

. label variable age "Age (in years)"

. label variable years_served "Years in Service"

. label variable rank_m "Officer Rank"

. label variable educ1 "Less than College"

. label variable educ2 "Completed College"

. label variable educ3 "Completed Post-College"

. 
. // Assign label to dependent variable
. label variable attendance "Attendance"

. 
. cd "~/Downloads/HRS_JOP2_Replication/3_Tables"
/Users/nravanilla/Downloads/HRS_JOP2_Replication/3_Tables

. 
. // Post descriptive statistics
. estpost sum psm ds grit bfi extroversion agreeable conscientious neuroticism op
> enness female age years_served rank_m educ1 educ2 educ3

             |  e(count)   e(sum_w)    e(mean)     e(Var)      e(sd)     e(min) 
-------------+------------------------------------------------------------------
         psm |       202        202   .7736813   .1436482   .3790094          0 
          ds |       180        180   6.597222   2.673456   1.635071        1.5 
        grit |       205        205   .7499527   .1826284   .4273504  -.1666667 
         bfi |       204        204    .955645   .1183947   .3440854          0 
extroversion |       204        204   .7531338   .2362481   .4860536        -.5 
   agreeable |       205        205    1.28043   .1854046   .4305864          0 
conscienti~s |       205        205   1.378808   .2379121   .4877624          0 
 neuroticism |       205        205   .8957259   .2165503   .4653497      -.375 
    openness |       205        205   .4602497   .2188735   .4678391       -.75 
      female |       206        206   .1796117   .1480701   .3847988          0 
         age |       206        206   38.04854   45.03178   6.710572         26 
years_served |       206        206    12.6699   40.26124   6.345174          2 
      rank_m |       206        206   4.014563   2.277836    1.50925          2 
       educ1 |       206        206   .0339806    .032986   .1816206          0 
       educ2 |       206        206   .8203883   .1480701   .3847988          0 
       educ3 |       206        206   .1456311   .1250296   .3535952          0 

             |    e(max)     e(sum) 
-------------+----------------------
         psm |     1.875   156.2836 
          ds |        10     1187.5 
        grit |  1.916667   153.7403 
         bfi |  1.811429   194.9516 
extroversion |         2   153.6393 
   agreeable |         2   262.4881 
conscienti~s |         2   282.6556 
 neuroticism |         2   183.6238 
    openness |       1.7   94.35119 
      female |         1         37 
         age |        55       7838 
years_served |        31       2610 
      rank_m |         8        827 
       educ1 |         1          7 
       educ2 |         1        169 
       educ3 |         1         30 

. 
. // Export the descriptive statistics to a CSV file with custom column labels an
> d custom rows at the bottom
. esttab using "Table_A1.csv", cells("mean sd min max") ///
> collabels("Mean" "St. Dev." "Min" "Max") label ///
> not addnotes("Number of Senior Police Officers = 95") replace
(output written to Table_A1.csv)

. 
. 
. ************
. * Table A7 *
. ************
. 
. keep if officer1!=.
(114 observations deleted)

. 
. global controls female age years_served rank_m educ1 educ2 o.educ3 ///
> blank_age blank_years_served blank_rank_m

. 
. foreach i in attendance {
  2. 
.     // Run the regression
.     reg `i' psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss ///
>     blank_bfi blank_psm blank_ds blank_grit ///
>     $controls, vce(cl sid_m)
  3.     
.     // Calculate the mean of the dependent variable and round it to 2 decimal p
> oints
.     sum `i'
  4.     local depvar_mean = round(r(mean), 0.01)
  5.     
.     // Store the estimates for this regression
.     estimates store reg_`i'
  6. 
.     // Output the regression table, only keeping the specified variables, hidin
> g the constant, and using labels
.     if "`i'" == "attendance" {
  7.         outreg2 [reg_`i'] using "Table_A7.xls", replace adjr2 tex dec(3) ///
>         keep(psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss) ///
>         addstat(Dep. Var. Mean, `depvar_mean') label
  8.     }
  9.     else {
 10.         outreg2 [reg_`i'] using "Table_A7.xls", append adjr2 tex dec(3) ///
>         keep(psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss) ///
>         addstat(Dep. Var. Mean, `depvar_mean') label
 11.     }
 12. }
note: blank_grit omitted because of collinearity.
note: blank_years_served omitted because of collinearity.
note: blank_rank_m omitted because of collinearity.

Linear regression                               Number of obs     =         92
                                                F(10, 91)         =          .
                                                Prob > F          =          .
                                                R-squared         =     0.1768
                                                Root MSE          =     .19919

                                   (Std. err. adjusted for 92 clusters in sid_m)
--------------------------------------------------------------------------------
               |               Robust
    attendance | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0016102    .027062     0.06   0.953    -.0521452    .0553656
    ds_z_wmiss |  -.0233372   .0193309    -1.21   0.230    -.0617356    .0150611
  grit_z_wmiss |   .0030994   .0323994     0.10   0.924    -.0612581     .067457
   bfi_z_wmiss |   -.006668   .0300821    -0.22   0.825    -.0664225    .0530865
     blank_bfi |    .120899   .1321608     0.91   0.363    -.1416222    .3834203
     blank_psm |  -.2119235    .112191    -1.89   0.062    -.4347771    .0109302
      blank_ds |   -.118889   .1199229    -0.99   0.324    -.3571012    .1193232
    blank_grit |          0  (omitted)
        female |  -.0838957   .1014564    -0.83   0.410    -.2854263     .117635
           age |    .002262   .0059565     0.38   0.705    -.0095699    .0140939
  years_served |   .0113631   .0064472     1.76   0.081    -.0014435    .0241697
        rank_m |  -.0226147   .0190567    -1.19   0.238    -.0604684     .015239
         educ1 |   .1080215    .106938     1.01   0.315    -.1043978    .3204407
         educ2 |  -.0946916   .0561379    -1.69   0.095    -.2062026    .0168194
         educ3 |          0  (omitted)
     blank_age |    .038083   .0846984     0.45   0.654    -.1301599     .206326
blank_years_~d |          0  (omitted)
  blank_rank_m |          0  (omitted)
         _cons |   .7592743   .1810339     4.19   0.000     .3996727    1.118876
--------------------------------------------------------------------------------

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  attendance |         92    .8208678    .2019509   .1666667          1
Table_A7.tex
Table_A7.xls
dir : seeout

. 
. 
. **************
. * Figure A.1 *
. **************
. 
. cd "~/Downloads/HRS_JOP2_Replication/4_Figures"
/Users/nravanilla/Downloads/HRS_JOP2_Replication/4_Figures

. 
. histogram attendance, density normal width(0.1) start(0) color(gs10) ///
> title("Community Policing Attendance Rate") xlabel(0(0.2)1, labsize(medium)) //
> /
> ylabel(, angle(0)) lwidth(medium) ///
> xtitle("Attendance Rate")
(bin=10, start=0, width=.1)

. graph export "histogram_attendance.png", as(png) replace
file
    /Users/nravanilla/Downloads/HRS_JOP2_Replication/4_Figures/histogram_attend
    > ance.png saved as PNG format

. 
. 
. ************
. * Table A2 *
. ************
. 
. cd "~/Downloads/HRS_JOP2_Replication/2_Data"
/Users/nravanilla/Downloads/HRS_JOP2_Replication/2_Data

. 
. use "Officer-CommunityLeader-Level Data.dta",clear

. 
. 
. *Do summary stats after running the code lines above
. 
. estpost sum captain kagawad chieftanod age_e education_e employed_e income_e //
> /
> reside_years_e male_e assets_roof_e years_served_e ///
> c10_population c10_male c10_hhsize c10_ofw c10_education c10_age18_39 ///
> c10_ms_single c10_catholic c10_ip c10_home_good npa_2015 dist_mps acrime_num_m 
> ///
> effort reliable responsive experience creative ///
> trustworthy approach confident empathy overall ///
> responsive_act_e polcaseserious_e polcap_timely_e ///
> polint_corrupt_rc_e polint_quality_e satis_trust_e satis_general_e

             |  e(count)   e(sum_w)    e(mean)     e(Var)      e(sd)     e(min) 
-------------+------------------------------------------------------------------
     captain |       284        284    .334507   .2233987   .4726507          0 
     kagawad |       284        284    .306338   .2132459   .4617856          0 
  chieftanod |       284        284   .3591549    .230976   .4805996          0 
       age_e |       284        284   52.13028   95.62608   9.778859         24 
 education_e |       284        284   1.890845   1.942107   1.393595          0 
  employed_e |       284        284   1.933099   1.794095   1.339438          1 
    income_e |       283        283   12873.12   4.97e+08   22283.82          0 
reside_yea~e |       281        281    45.1637   209.9088   14.48823          5 
      male_e |       280        280   .8964286   .0931772   .3052493          0 
assets_roo~e |       284        284   4.221831   77.04956   8.777788          1 
years_serv~e |       283        283   6.939929   31.18432   5.584292          0 
c10_popula~n |       284        284    918.081   257942.8   507.8807        162 
    c10_male |       284        284   .4984409   .0003479    .018651   .4403409 
  c10_hhsize |       284        284   3.257005    .158503   .3981243   2.298701 
     c10_ofw |       284        284   .0124145   .0001498   .0122384          0 
c10_educat~n |       284        284    1.87478   .0703974   .2653251   1.373796 
c10_age18_39 |       284        284    .535012   .0021778   .0466671   .3937107 
c10_ms_sin~e |       284        284   .2791593   .0015675   .0395922     .19678 
c10_catholic |       284        284   .9535117   .0011632   .0341052   .8386606 
      c10_ip |       284        284   .0053091     .00008   .0089462          0 
c10_home_g~d |       284        284   .3796026   .0004612   .0214751   .3292469 
    npa_2015 |       284        284   .2570423   .2199149   .4689508          0 
    dist_mps |       282        282   4.167979   11.68201   3.417895   .1033291 
acrime_num_m |       284        284   5.151408   62.65897   7.915742          0 
      effort |       257        257   1.996109   .9960786   .9980373         -2 
    reliable |       257        257   2.042802   .9161296   .9571466         -2 
  responsive |       256        256    1.84375   1.191176    1.09141         -3 
  experience |       248        248   1.729839    1.40445   1.185095         -3 
    creative |       251        251    1.63745   1.296032   1.138434         -2 
 trustworthy |       252        252   2.146825   .9942927   .9971423         -3 
    approach |       250        250       2.22   .8389558   .9159453         -1 
   confident |       250        250      2.072   .9586506    .979107         -1 
     empathy |       242        242   1.859504   1.216694   1.103038         -3 
     overall |       248        248   2.080645   .8922555   .9445927         -2 
responsive~e |       283        283   1.388693   .5576022   .7467277         -1 
polcaseser~e |       283        283   1.491166    .456482   .6756345         -1 
polcap_tim~e |       280        280   1.271429   .6715822   .8195012         -2 
polint_cor~e |       272        272   3.231618   .8575944   .9260639          0 
polint_qua~e |       282        282   1.283688   .6309785   .7943416         -2 
satis_trus~e |       283        283   1.515901   .3712002    .609262          0 
satis_gene~e |       284        284   1.330986   .5614393   .7492925         -1 

             |    e(max)     e(sum) 
-------------+----------------------
     captain |         1         95 
     kagawad |         1         87 
  chieftanod |         1        102 
       age_e |        80      14805 
 education_e |         5        537 
  employed_e |         5        549 
    income_e |    300000    3643092 
reside_yea~e |        80      12691 
      male_e |         1        251 
assets_roo~e |        88       1199 
years_serv~e |        33       1964 
c10_popula~n |      2839     260735 
    c10_male |  .5550458   141.5572 
  c10_hhsize |  4.648649   924.9896 
     c10_ofw |  .0681004   3.525729 
c10_educat~n |  2.652422   532.4376 
c10_age18_39 |  .6222826   151.9434 
c10_ms_sin~e |   .381579   79.28123 
c10_catholic |  .9989178   270.7973 
      c10_ip |  .0502661   1.507788 
c10_home_g~d |  .4362416   107.8071 
    npa_2015 |         2         73 
    dist_mps |   14.5856    1175.37 
acrime_num_m |        53       1463 
      effort |         3        513 
    reliable |         3        525 
  responsive |         3        472 
  experience |         3        429 
    creative |         3        411 
 trustworthy |         3        541 
    approach |         3        555 
   confident |         3        518 
     empathy |         3        450 
     overall |         3        516 
responsive~e |         2        393 
polcaseser~e |         2        422 
polcap_tim~e |         2        356 
polint_cor~e |         4        879 
polint_qua~e |         2        362 
satis_trus~e |         2        429 
satis_gene~e |         2        378 

. 
. // Assign labels to independent variables
. label variable psm_z_wmiss "Public Service Motivation"

. label variable ds_z_wmiss "Cognitive Ability (Digit Span Score)"

. label variable grit_z_wmiss "Grit Scale"

. label variable bfi_z_wmiss "Big 5 Personality Index"

. label variable extroversion_z_wmiss "Extraversion"

. label variable agreeable_z_wmiss "Agreeableness"

. label variable conscientious_z_wmiss "Conscientiousness"

. label variable neuroticism_z_wmiss "Neuroticism (Reverse-coded)"

. label variable openness_z_wmiss "Openness"

. 
. // Assign labels to dependent variables
. label variable effort "Effort"

. label variable reliable "Reliability"

. label variable responsive "Responsiveness"

. label variable experience "Experience"

. label variable creative "Creativity"

. label variable trustworthy "Trustworthiness"

. label variable approach "Approachability"

. label variable confident "Confidence"

. label variable empathy "Empathy"

. label variable overall "Overall"

. 
. label variable responsive_act_e "Acts on citizen feedback"

. label variable polcaseserious_e "Takes citizen report seriously"

. label variable polcap_timely_e "Responds timely"

. label variable polint_corrupt_rc_e "Not corrupt"

. label variable polint_quality_e "Provides equal service"

. label variable satis_trust_e "I trust the police"

. label variable satis_general_e "Provides satisfactory service"

. 
. // Asign labels to barangay-level controls
. label variable c10_population "Population"

. label variable c10_male "Share of Male Residents"

. label variable c10_hhsize "Average Household Size"

. label variable c10_ofw "Share of Overseas Filipino Workers (OFW)"

. label variable c10_education "Average Education"

. label variable c10_age18_39 "Share Age"

. label variable c10_ms_single "Share of Unmarried Residents"

. label variable c10_catholic "Share Catholic Residents"

. label variable c10_ip "Share of Indigenous Population"

. label variable c10_home_good "Share of Home Goods"

. label variable npa_2015 "Rebel Presence Rating in 2015"

. label variable dist_mps "Average Distance From a Police Station (km)"

. label variable acrime_num_m "Baseline Crime Rate"

. 
. // Asign labels to community leaders'-level controls
. label variable captain "Barangay Kapitan = 1"

. label variable kagawad "Barangay Kagawad = 1"

. label variable chieftanod "Barangay Tanod = 1"

. label variable age_e "Age (in years)"

. label variable education_e "Educational Attainment"

. label variable employed_e "Employment Status"

. label variable income_e "Monthly Income (Pesos)"

. label variable reside_years_e "Years in Residence"

. label variable male_e "Male = 1"

. label variable assets_roof_e "Assets"

. label variable years_served_e "Years in Service"

. 
. //Assign labels to officer-level controls
. label variable female "Female"

. label variable age "Age (in years)"

. label variable years_served "Years in Service"

. label variable rank_m "Officer Rank"

. label variable educ1 "Less than College"

. label variable educ2 "Completed College"

. label variable educ3 "Completed Post-College"

. 
. // Assign labels to Junior officer indexes of traits
. label variable psm2_z_wmiss "Public Service Motivation (Junior)"

. label variable ds2_z_wmiss "Cognitive Ability (Digit Span Score) (Junior)"

. label variable grit2_z_wmiss "Grit Scale (Junior)"

. label variable bfi2_z_wmiss "Big 5 Personality Index (Junior)"

. 
. global controls_bgy c10_population c10_male c10_hhsize c10_ofw c10_education c1
> 0_age18_39 ///
> c10_ms_single c10_catholic c10_ip c10_home_good npa_2015 dist_mps acrime_num_m

. 
. global controls_bgy_respondents captain kagawad o.chieftanod age_e education_e 
> employed_e income_e ///
> reside_years_e male_e assets_roof_e years_served_e

. 
. global controls_officer female age years_served rank_m educ1 o.educ2 educ3

. 
. global controls_junior psm2_z_wmiss ds2_z_wmiss grit2_z_wmiss bfi2_z_wmiss

. 
. 
. cd "~/Downloads/HRS_JOP2_Replication/3_Tables"
/Users/nravanilla/Downloads/HRS_JOP2_Replication/3_Tables

. 
. // Generate summary statistics
. estpost sum captain kagawad chieftanod age_e education_e employed_e income_e //
> /
> reside_years_e male_e assets_roof_e years_served_e ///
> c10_population c10_male c10_hhsize c10_ofw c10_education c10_age18_39 ///
> c10_ms_single c10_catholic c10_ip c10_home_good npa_2015 dist_mps acrime_num_m 
> ///
> effort reliable responsive experience creative ///
> trustworthy approach confident empathy overall ///
> responsive_act_e polcaseserious_e polcap_timely_e ///
> polint_corrupt_rc_e polint_quality_e satis_trust_e satis_general_e

             |  e(count)   e(sum_w)    e(mean)     e(Var)      e(sd)     e(min) 
-------------+------------------------------------------------------------------
     captain |       284        284    .334507   .2233987   .4726507          0 
     kagawad |       284        284    .306338   .2132459   .4617856          0 
  chieftanod |       284        284   .3591549    .230976   .4805996          0 
       age_e |       284        284   52.13028   95.62608   9.778859         24 
 education_e |       284        284   1.890845   1.942107   1.393595          0 
  employed_e |       284        284   1.933099   1.794095   1.339438          1 
    income_e |       283        283   12873.12   4.97e+08   22283.82          0 
reside_yea~e |       281        281    45.1637   209.9088   14.48823          5 
      male_e |       280        280   .8964286   .0931772   .3052493          0 
assets_roo~e |       284        284   4.221831   77.04956   8.777788          1 
years_serv~e |       283        283   6.939929   31.18432   5.584292          0 
c10_popula~n |       284        284    918.081   257942.8   507.8807        162 
    c10_male |       284        284   .4984409   .0003479    .018651   .4403409 
  c10_hhsize |       284        284   3.257005    .158503   .3981243   2.298701 
     c10_ofw |       284        284   .0124145   .0001498   .0122384          0 
c10_educat~n |       284        284    1.87478   .0703974   .2653251   1.373796 
c10_age18_39 |       284        284    .535012   .0021778   .0466671   .3937107 
c10_ms_sin~e |       284        284   .2791593   .0015675   .0395922     .19678 
c10_catholic |       284        284   .9535117   .0011632   .0341052   .8386606 
      c10_ip |       284        284   .0053091     .00008   .0089462          0 
c10_home_g~d |       284        284   .3796026   .0004612   .0214751   .3292469 
    npa_2015 |       284        284   .2570423   .2199149   .4689508          0 
    dist_mps |       282        282   4.167979   11.68201   3.417895   .1033291 
acrime_num_m |       284        284   5.151408   62.65897   7.915742          0 
      effort |       257        257   1.996109   .9960786   .9980373         -2 
    reliable |       257        257   2.042802   .9161296   .9571466         -2 
  responsive |       256        256    1.84375   1.191176    1.09141         -3 
  experience |       248        248   1.729839    1.40445   1.185095         -3 
    creative |       251        251    1.63745   1.296032   1.138434         -2 
 trustworthy |       252        252   2.146825   .9942927   .9971423         -3 
    approach |       250        250       2.22   .8389558   .9159453         -1 
   confident |       250        250      2.072   .9586506    .979107         -1 
     empathy |       242        242   1.859504   1.216694   1.103038         -3 
     overall |       248        248   2.080645   .8922555   .9445927         -2 
responsive~e |       283        283   1.388693   .5576022   .7467277         -1 
polcaseser~e |       283        283   1.491166    .456482   .6756345         -1 
polcap_tim~e |       280        280   1.271429   .6715822   .8195012         -2 
polint_cor~e |       272        272   3.231618   .8575944   .9260639          0 
polint_qua~e |       282        282   1.283688   .6309785   .7943416         -2 
satis_trus~e |       283        283   1.515901   .3712002    .609262          0 
satis_gene~e |       284        284   1.330986   .5614393   .7492925         -1 

             |    e(max)     e(sum) 
-------------+----------------------
     captain |         1         95 
     kagawad |         1         87 
  chieftanod |         1        102 
       age_e |        80      14805 
 education_e |         5        537 
  employed_e |         5        549 
    income_e |    300000    3643092 
reside_yea~e |        80      12691 
      male_e |         1        251 
assets_roo~e |        88       1199 
years_serv~e |        33       1964 
c10_popula~n |      2839     260735 
    c10_male |  .5550458   141.5572 
  c10_hhsize |  4.648649   924.9896 
     c10_ofw |  .0681004   3.525729 
c10_educat~n |  2.652422   532.4376 
c10_age18_39 |  .6222826   151.9434 
c10_ms_sin~e |   .381579   79.28123 
c10_catholic |  .9989178   270.7973 
      c10_ip |  .0502661   1.507788 
c10_home_g~d |  .4362416   107.8071 
    npa_2015 |         2         73 
    dist_mps |   14.5856    1175.37 
acrime_num_m |        53       1463 
      effort |         3        513 
    reliable |         3        525 
  responsive |         3        472 
  experience |         3        429 
    creative |         3        411 
 trustworthy |         3        541 
    approach |         3        555 
   confident |         3        518 
     empathy |         3        450 
     overall |         3        516 
responsive~e |         2        393 
polcaseser~e |         2        422 
polcap_tim~e |         2        356 
polint_cor~e |         4        879 
polint_qua~e |         2        362 
satis_trus~e |         2        429 
satis_gene~e |         2        378 

. 
. // Export the descriptive statistics to a CSV file with custom column labels an
> d custom rows at the bottom
. esttab using "Table_A2.csv", cells("mean sd min max") ///
> collabels("Mean" "St. Dev." "Min" "Max") label ///
> not addnotes("Number of Barangays = 95") replace
(output written to Table_A2.csv)

. 
. 
. ************
. * Table A3 *
. ************
. 
. foreach i in effort reliable responsive experience creative trustworthy approac
> h confident empathy overall {
  2. 
.     // Run the regression
.     reg `i' psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss ///
>     $controls_bgy, vce(cl bgy)
  3.     
.     // Perform the F-test
.     test psm_z_wmiss = ds_z_wmiss = grit_z_wmiss = bfi_z_wmiss
  4.     
.     // Capture the p-value from the F-test and round it to 3 decimal points
.     local p_value = round(r(p), 0.001)
  5.     
.     // Calculate the mean of the dependent variable and round it to 2 decimal p
> oints
.     sum `i'
  6.     local depvar_mean = round(r(mean), 0.01)
  7.     
.     // Store the estimates for this regression
.     estimates store reg_`i'
  8. 
.     // Output the regression table, only keeping the specified variables, hidin
> g the constant, and using labels
.     if "`i'" == "effort" {
  9.         outreg2 [reg_`i'] using "Table_A3.xls", replace tex dec(3) ///
>         keep(psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 10.     }
 11.     else {
 12.         outreg2 [reg_`i'] using "Table_A3.xls", append tex dec(3) ///
>         keep(psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 13.     }
 14. 
.     // Optionally display the rounded p-value and dependent variable mean in th
> e console for confirmation
.     di "F-test p-value for `i': `p_value', Dependent variable mean: `depvar_mea
> n'"
 15. }

Linear regression                               Number of obs     =        255
                                                F(17, 92)         =       2.78
                                                Prob > F          =     0.0009
                                                R-squared         =     0.1002
                                                Root MSE          =     .98394

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
        effort | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1790198   .0703629     2.54   0.013      .039273    .3187666
    ds_z_wmiss |  -.1530072   .0578933    -2.64   0.010    -.2679884    -.038026
  grit_z_wmiss |   .1724542    .064975     2.65   0.009     .0434082    .3015002
   bfi_z_wmiss |  -.1245993   .0709265    -1.76   0.082    -.2654655    .0162669
c10_population |   .0000523   .0001268     0.41   0.681    -.0001995    .0003041
      c10_male |    -.59082   4.789122    -0.12   0.902    -10.10243    8.920789
    c10_hhsize |   -.081273   .2459246    -0.33   0.742    -.5697004    .4071544
       c10_ofw |  -8.004492   4.325237    -1.85   0.067    -16.59479    .5858008
 c10_education |   1.085217   .4795632     2.26   0.026     .1327634    2.037671
  c10_age18_39 |  -.2909892    1.64008    -0.18   0.860    -3.548329    2.966351
 c10_ms_single |  -3.850067   2.996878    -1.28   0.202    -9.802124    2.101991
  c10_catholic |   -.087938   2.188191    -0.04   0.968    -4.433875    4.257999
        c10_ip |   7.425287   7.927224     0.94   0.351    -8.318865    23.16944
 c10_home_good |   -4.36221   5.475965    -0.80   0.428    -15.23795     6.51353
      npa_2015 |  -.0215642   .1356501    -0.16   0.874     -.290977    .2478486
      dist_mps |  -.0097241   .0226576    -0.43   0.669     -.054724    .0352758
  acrime_num_m |  -.0066564    .009772    -0.68   0.497    -.0260645    .0127516
         _cons |   3.587777   4.970774     0.72   0.472     -6.28461    13.46016
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    8.94
            Prob > F =    0.0000

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
      effort |        257    1.996109    .9980373         -2          3
Table_A3.tex
Table_A3.xls
dir : seeout
F-test p-value for effort: 0, Dependent variable mean: 2

Linear regression                               Number of obs     =        255
                                                F(17, 92)         =       1.40
                                                Prob > F          =     0.1558
                                                R-squared         =     0.0706
                                                Root MSE          =     .95902

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
      reliable | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2056441   .0757737     2.71   0.008      .055151    .3561371
    ds_z_wmiss |  -.1002935   .0601222    -1.67   0.099    -.2197015    .0191144
  grit_z_wmiss |   .0531523   .0730013     0.73   0.468    -.0918347    .1981393
   bfi_z_wmiss |  -.1087153   .0802018    -1.36   0.179    -.2680029    .0505723
c10_population |  -.0000403   .0001604    -0.25   0.802     -.000359    .0002784
      c10_male |   -1.31979   4.759033    -0.28   0.782    -10.77164     8.13206
    c10_hhsize |  -.0910986   .2512054    -0.36   0.718    -.5900142     .407817
       c10_ofw |  -8.674604   5.468776    -1.59   0.116    -19.53607    2.186857
 c10_education |    .680555    .452052     1.51   0.136    -.2172593    1.578369
  c10_age18_39 |  -.4456993   1.722616    -0.26   0.796    -3.866964    2.975566
 c10_ms_single |   -2.28264   3.081684    -0.74   0.461     -8.40313    3.837851
  c10_catholic |  -1.653807   1.781747    -0.93   0.356    -5.192509    1.884896
        c10_ip |   3.055424   9.116933     0.34   0.738    -15.05159    21.16244
 c10_home_good |  -1.554368   5.669258    -0.27   0.785      -12.814    9.705267
      npa_2015 |   .0413116   .1381556     0.30   0.766    -.2330774    .3157005
      dist_mps |  -.0090305   .0251584    -0.36   0.720    -.0589973    .0409363
  acrime_num_m |  -.0093561   .0106959    -0.87   0.384    -.0305991    .0118869
         _cons |   4.971612   4.804975     1.03   0.304    -4.571483    14.51471
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    3.71
            Prob > F =    0.0144

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    reliable |        257    2.042802    .9571466         -2          3
Table_A3.tex
Table_A3.xls
dir : seeout
F-test p-value for reliable: .014, Dependent variable mean: 2.04

Linear regression                               Number of obs     =        254
                                                F(17, 92)         =       2.15
                                                Prob > F          =     0.0109
                                                R-squared         =     0.0956
                                                Root MSE          =     1.0788

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
    responsive | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0958112    .078983     1.21   0.228    -.0610557    .2526782
    ds_z_wmiss |  -.2001521   .0637733    -3.14   0.002    -.3268114   -.0734929
  grit_z_wmiss |  -.0662788   .0805394    -0.82   0.413     -.226237    .0936794
   bfi_z_wmiss |   .0095246   .0935471     0.10   0.919     -.176268    .1953172
c10_population |   .0000842   .0002025     0.42   0.679    -.0003181    .0004865
      c10_male |  -6.539352   6.020745    -1.09   0.280    -18.49707    5.418368
    c10_hhsize |  -.2544582   .2411909    -1.06   0.294    -.7334841    .2245677
       c10_ofw |   2.909636     8.6341     0.34   0.737    -14.23843     20.0577
 c10_education |   .1131427   .6194774     0.18   0.855    -1.117193    1.343478
  c10_age18_39 |   .9206826   1.985815     0.46   0.644    -3.023316    4.864682
 c10_ms_single |  -5.726229   3.451565    -1.66   0.101    -12.58134    1.128878
  c10_catholic |   .3870966   2.359636     0.16   0.870    -4.299343    5.073536
        c10_ip |   6.207108   6.770416     0.92   0.362    -7.239524    19.65374
 c10_home_good |  -13.52263   6.001744    -2.25   0.027    -25.44261   -1.602645
      npa_2015 |     .19943   .1402229     1.42   0.158    -.0790648    .4779249
      dist_mps |  -.0390202    .028719    -1.36   0.178    -.0960585    .0180182
  acrime_num_m |  -.0069817   .0089809    -0.78   0.439    -.0248185    .0108551
         _cons |    11.5912   5.696855     2.03   0.045     .2767508    22.90564
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    3.35
            Prob > F =    0.0225

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  responsive |        256     1.84375     1.09141         -3          3
Table_A3.tex
Table_A3.xls
dir : seeout
F-test p-value for responsive: .022, Dependent variable mean: 1.84

Linear regression                               Number of obs     =        246
                                                F(17, 92)         =       2.19
                                                Prob > F          =     0.0091
                                                R-squared         =     0.1103
                                                Root MSE          =     1.1625

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
    experience | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2390764   .1020851     2.34   0.021     .0363266    .4418261
    ds_z_wmiss |  -.1347184   .0810674    -1.66   0.100    -.2957253    .0262885
  grit_z_wmiss |   -.093782    .104415    -0.90   0.371    -.3011592    .1135951
   bfi_z_wmiss |  -.0626726   .1109017    -0.57   0.573     -.282933    .1575878
c10_population |   .0003368   .0001997     1.69   0.095    -.0000599    .0007335
      c10_male |   .6692053   6.655313     0.10   0.920    -12.54882    13.88723
    c10_hhsize |  -.2733791   .3129754    -0.87   0.385    -.8949753    .3482171
       c10_ofw |   1.982726   6.590437     0.30   0.764    -11.10645     15.0719
 c10_education |   .4029556   .6571513     0.61   0.541    -.9022036    1.708115
  c10_age18_39 |   -1.39991   2.023173    -0.69   0.491    -5.418107    2.618286
 c10_ms_single |  -7.195246   3.801088    -1.89   0.062    -14.74453     .354042
  c10_catholic |   1.807854    2.74691     0.66   0.512    -3.647747    7.263454
        c10_ip |   5.323109   8.773248     0.61   0.546    -12.10132    22.74754
 c10_home_good |   -11.9001   7.063483    -1.68   0.095    -25.92879    2.128587
      npa_2015 |   .2029362   .2283753     0.89   0.377    -.2506369    .6565093
      dist_mps |  -.0724002    .030297    -2.39   0.019    -.1325727   -.0122277
  acrime_num_m |   .0020775    .010239     0.20   0.840     -.018258    .0224129
         _cons |   6.964315   6.081338     1.15   0.255    -5.113747    19.04238
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    2.84
            Prob > F =    0.0420

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  experience |        248    1.729839    1.185095         -3          3
Table_A3.tex
Table_A3.xls
dir : seeout
F-test p-value for experience: .042, Dependent variable mean: 1.73

Linear regression                               Number of obs     =        249
                                                F(17, 91)         =       1.68
                                                Prob > F          =     0.0618
                                                R-squared         =     0.0997
                                                Root MSE          =     1.1233

                                     (Std. err. adjusted for 92 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
      creative | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2138363   .0998364     2.14   0.035     .0155235    .4121492
    ds_z_wmiss |  -.1001967   .0694025    -1.44   0.152    -.2380563    .0376629
  grit_z_wmiss |   .0170012   .0928883     0.18   0.855      -.16751    .2015123
   bfi_z_wmiss |  -.0192731   .1064841    -0.18   0.857    -.2307906    .1922444
c10_population |   .0001675   .0001832     0.91   0.363    -.0001963    .0005314
      c10_male |  -5.595561   5.986163    -0.93   0.352    -17.48634    6.295218
    c10_hhsize |  -.4225113   .2945992    -1.43   0.155    -1.007696    .1626739
       c10_ofw |  -5.766176   8.887238    -0.65   0.518    -23.41958    11.88723
 c10_education |  -.1524647   .6095422    -0.25   0.803    -1.363245    1.058316
  c10_age18_39 |  -1.889584    2.22107    -0.85   0.397    -6.301466    2.522298
 c10_ms_single |  -.5244629   3.543481    -0.15   0.883    -7.563152    6.514226
  c10_catholic |   -6.07516   2.180203    -2.79   0.006    -10.40586   -1.744456
        c10_ip |   .6086728   10.52138     0.06   0.954    -20.29075    21.50809
 c10_home_good |  -8.874535   6.730504    -1.32   0.191    -22.24385    4.494784
      npa_2015 |  -.0047381   .1565927    -0.03   0.976    -.3157903    .3063142
      dist_mps |   .0079912   .0275769     0.29   0.773     -.046787    .0627693
  acrime_num_m |  -.0027632   .0115227    -0.24   0.811    -.0256515    .0201252
         _cons |   16.30346   5.816744     2.80   0.006     4.749213    27.85771
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    91) =    2.21
            Prob > F =    0.0919

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    creative |        251     1.63745    1.138434         -2          3
Table_A3.tex
Table_A3.xls
dir : seeout
F-test p-value for creative: .092, Dependent variable mean: 1.64

Linear regression                               Number of obs     =        250
                                                F(17, 92)         =       0.97
                                                Prob > F          =     0.4927
                                                R-squared         =     0.0823
                                                Root MSE          =     .99347

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
   trustworthy | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2168937   .0803039     2.70   0.008     .0574032    .3763841
    ds_z_wmiss |  -.1121141   .0669379    -1.67   0.097    -.2450586    .0208304
  grit_z_wmiss |  -.1373031   .1008456    -1.36   0.177    -.3375912     .062985
   bfi_z_wmiss |  -.0734195   .0794639    -0.92   0.358    -.2312416    .0844026
c10_population |  -.0000338   .0001552    -0.22   0.828    -.0003421    .0002744
      c10_male |  -9.085822   6.246371    -1.45   0.149    -21.49165    3.320009
    c10_hhsize |  -.0848008   .2811209    -0.30   0.764    -.6431311    .4735295
       c10_ofw |  -1.874626    5.86879    -0.32   0.750    -13.53055    9.781298
 c10_education |   .4526542    .551007     0.82   0.413    -.6416933    1.547002
  c10_age18_39 |   2.196827   1.945285     1.13   0.262    -1.666677    6.060331
 c10_ms_single |  -2.405588   3.448251    -0.70   0.487    -9.254112    4.442935
  c10_catholic |   1.436026   2.127744     0.67   0.501    -2.789857     5.66191
        c10_ip |   10.57321   7.883412     1.34   0.183     -5.08393    26.23034
 c10_home_good |  -1.345042   6.997469    -0.19   0.848    -15.24262    12.55254
      npa_2015 |   .1895996    .186352     1.02   0.312    -.1805115    .5597107
      dist_mps |   .0225015   .0298754     0.75   0.453    -.0368337    .0818367
  acrime_num_m |  -.0109416   .0096787    -1.13   0.261    -.0301642    .0082811
         _cons |   4.656636   5.555284     0.84   0.404    -6.376637    15.68991
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    3.12
            Prob > F =    0.0298

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
 trustworthy |        252    2.146825    .9971423         -3          3
Table_A3.tex
Table_A3.xls
dir : seeout
F-test p-value for trustworthy: .03, Dependent variable mean: 2.15

Linear regression                               Number of obs     =        248
                                                F(17, 92)         =       1.15
                                                Prob > F          =     0.3171
                                                R-squared         =     0.0637
                                                Root MSE          =     .91875

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
      approach | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1489951   .0671134     2.22   0.029      .015702    .2822882
    ds_z_wmiss |  -.0797921   .0628359    -1.27   0.207    -.2045897    .0450054
  grit_z_wmiss |  -.0852359   .0688981    -1.24   0.219    -.2220734    .0516017
   bfi_z_wmiss |  -.0772046   .0741184    -1.04   0.300      -.22441    .0700009
c10_population |  -8.29e-06   .0001687    -0.05   0.961    -.0003433    .0003267
      c10_male |  -3.291363   4.467906    -0.74   0.463    -12.16501    5.582284
    c10_hhsize |   .0337932   .1838958     0.18   0.855    -.3314398    .3990262
       c10_ofw |  -5.502013   4.923085    -1.12   0.267    -15.27969    4.275659
 c10_education |   .6528145   .4393059     1.49   0.141     -.219685    1.525314
  c10_age18_39 |   1.438368   1.700706     0.85   0.400    -1.939381    4.816118
 c10_ms_single |  -2.447735    3.03638    -0.81   0.422    -8.478248    3.582777
  c10_catholic |   1.400629   1.893547     0.74   0.461    -2.360119    5.161377
        c10_ip |   9.288422   6.793683     1.37   0.175    -4.204419    22.78126
 c10_home_good |   1.512316   5.906503     0.26   0.798    -10.21851    13.24314
      npa_2015 |   .1788835    .141536     1.26   0.209    -.1022191    .4599862
      dist_mps |   .0032169   .0188408     0.17   0.865    -.0342025    .0406363
  acrime_num_m |  -.0142357   .0094415    -1.51   0.135    -.0329874     .004516
         _cons |   .5784943   4.626481     0.13   0.901    -8.610097    9.767086
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    2.11
            Prob > F =    0.1044

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    approach |        250        2.22    .9159453         -1          3
Table_A3.tex
Table_A3.xls
dir : seeout
F-test p-value for approach: .104, Dependent variable mean: 2.22

Linear regression                               Number of obs     =        248
                                                F(17, 92)         =       1.72
                                                Prob > F          =     0.0520
                                                R-squared         =     0.0690
                                                Root MSE          =     .97405

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
     confident | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1933906   .0638099     3.03   0.003     .0666586    .3201225
    ds_z_wmiss |  -.1826211   .0577779    -3.16   0.002    -.2973729   -.0678693
  grit_z_wmiss |  -.0135136   .0654484    -0.21   0.837    -.1434997    .1164725
   bfi_z_wmiss |  -.0955195   .0689644    -1.39   0.169    -.2324888    .0414499
c10_population |    .000106   .0001292     0.82   0.414    -.0001505    .0003626
      c10_male |   1.346393   3.892981     0.35   0.730    -6.385403    9.078189
    c10_hhsize |  -.0355137   .2631722    -0.13   0.893    -.5581964     .487169
       c10_ofw |  -4.114523   4.877074    -0.84   0.401    -13.80081    5.571768
 c10_education |   .5221013   .4482793     1.16   0.247      -.36822    1.412423
  c10_age18_39 |  -1.020411   1.762947    -0.58   0.564    -4.521775    2.480953
 c10_ms_single |  -2.919005   2.698413    -1.08   0.282    -8.278286    2.440276
  c10_catholic |  -.8197809   2.112845    -0.39   0.699    -5.016074    3.376512
        c10_ip |   8.686125   5.731245     1.52   0.133    -2.696622    20.06887
 c10_home_good |  -4.081775   6.112398    -0.67   0.506    -16.22153    8.057974
      npa_2015 |   .0395395   .1565224     0.25   0.801    -.2713276    .3504066
      dist_mps |   .0111163   .0251008     0.44   0.659     -.038736    .0609687
  acrime_num_m |  -.0098122   .0081348    -1.21   0.231    -.0259687    .0063442
         _cons |   4.150039   4.879359     0.85   0.397    -5.540789    13.84087
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    6.72
            Prob > F =    0.0004

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   confident |        250       2.072     .979107         -1          3
Table_A3.tex
Table_A3.xls
dir : seeout
F-test p-value for confident: 0, Dependent variable mean: 2.07

Linear regression                               Number of obs     =        240
                                                F(17, 91)         =       3.71
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1035
                                                Root MSE          =     1.0867

                                     (Std. err. adjusted for 92 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
       empathy | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1729217   .0819914     2.11   0.038     .0100559    .3357874
    ds_z_wmiss |  -.1910832   .0598511    -3.19   0.002    -.3099701   -.0721963
  grit_z_wmiss |   .1732571   .0801562     2.16   0.033     .0140366    .3324775
   bfi_z_wmiss |   -.190097   .0799936    -2.38   0.020    -.3489943   -.0311996
c10_population |   .0003591   .0001399     2.57   0.012     .0000811    .0006371
      c10_male |  -4.717514   4.466498    -1.06   0.294    -13.58966    4.154636
    c10_hhsize |  -.0459666   .2637994    -0.17   0.862    -.5699717    .4780385
       c10_ofw |    -10.694   5.882688    -1.82   0.072    -22.37924    .9912357
 c10_education |  -.1443123   .5137418    -0.28   0.779    -1.164797    .8761727
  c10_age18_39 |  -.6567995   1.635382    -0.40   0.689    -3.905284    2.591685
 c10_ms_single |  -.8590085   2.849943    -0.30   0.764    -6.520069    4.802052
  c10_catholic |  -1.857184   2.065497    -0.90   0.371     -5.96004    2.245672
        c10_ip |  -2.412652   7.006906    -0.34   0.731    -16.33101    11.50571
 c10_home_good |  -3.298379   5.760956    -0.57   0.568    -14.74181    8.145053
      npa_2015 |   .1237863   .1610591     0.77   0.444    -.1961379    .4437105
      dist_mps |  -.0366176   .0232681    -1.57   0.119    -.0828369    .0096016
  acrime_num_m |  -.0023619   .0116341    -0.20   0.840    -.0254716    .0207477
         _cons |   8.208972   4.565391     1.80   0.075    -.8596159    17.27756
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    91) =   10.60
            Prob > F =    0.0000

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
     empathy |        242    1.859504    1.103038         -3          3
Table_A3.tex
Table_A3.xls
dir : seeout
F-test p-value for empathy: 0, Dependent variable mean: 1.86

Linear regression                               Number of obs     =        246
                                                F(17, 91)         =       1.65
                                                Prob > F          =     0.0685
                                                R-squared         =     0.0697
                                                Root MSE          =     .94828

                                     (Std. err. adjusted for 92 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
       overall | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1749537   .0652942     2.68   0.009     .0452547    .3046527
    ds_z_wmiss |  -.1001085   .0531647    -1.88   0.063    -.2057136    .0054965
  grit_z_wmiss |  -.0036481   .0677404    -0.05   0.957     -.138206    .1309098
   bfi_z_wmiss |  -.0502283   .0846079    -0.59   0.554    -.2182916    .1178349
c10_population |  -.0000184   .0001814    -0.10   0.920    -.0003787     .000342
      c10_male |  -4.642063   5.087622    -0.91   0.364      -14.748    5.463873
    c10_hhsize |  -.0853191   .2707586    -0.32   0.753    -.6231479    .4525096
       c10_ofw |  -.2992562   6.249094    -0.05   0.962    -12.71231     12.1138
 c10_education |   .4394095    .511498     0.86   0.393    -.5766185    1.455438
  c10_age18_39 |   2.927478   2.024967     1.45   0.152     -1.09487    6.949827
 c10_ms_single |  -1.145643   2.553451    -0.45   0.655     -6.21776    3.926475
  c10_catholic |  -.1798795   2.152386    -0.08   0.934    -4.455331    4.095572
        c10_ip |   7.291207   6.951177     1.05   0.297    -6.516452    21.09887
 c10_home_good |  -.1548756   5.459391    -0.03   0.977    -10.99928    10.68953
      npa_2015 |   .0687965   .1485002     0.46   0.644    -.2261809     .363774
      dist_mps |   .0044968   .0286438     0.16   0.876    -.0524007    .0613942
  acrime_num_m |  -.0147161   .0089079    -1.65   0.102    -.0324104    .0029783
         _cons |   2.857569    5.03299     0.57   0.572    -7.139847    12.85498
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    91) =    3.40
            Prob > F =    0.0211

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
     overall |        248    2.080645    .9445927         -2          3
Table_A3.tex
Table_A3.xls
dir : seeout
F-test p-value for overall: .021, Dependent variable mean: 2.08

. 
. 
. ************
. * Table A8 *
. ************
. 
. foreach i in effort reliable responsive experience creative trustworthy approac
> h confident empathy overall {
  2. 
.     // Run the regression
.     reg `i' psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss, vce(cl bgy)
  3.     
.     // Perform the F-test
.     test psm_z_wmiss = ds_z_wmiss = grit_z_wmiss = bfi_z_wmiss
  4.     
.     // Capture the p-value from the F-test and round it to 3 decimal points
.     local p_value = round(r(p), 0.001)
  5.     
.     // Calculate the mean of the dependent variable and round it to 2 decimal p
> oints
.     sum `i'
  6.     local depvar_mean = round(r(mean), 0.01)
  7.     
.     // Store the estimates for this regression
.     estimates store reg_`i'
  8. 
.     // Output the regression table, only keeping the specified variables, hidin
> g the constant, and using labels
.     if "`i'" == "effort" {
  9.         outreg2 [reg_`i'] using "Table_A8.xls", replace tex dec(3) ///
>         keep(psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 10.     }
 11.     else {
 12.         outreg2 [reg_`i'] using "Table_A8.xls", append tex dec(3) ///
>         keep(psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 13.     }
 14. 
.     // Optionally display the rounded p-value and dependent variable mean in th
> e console for confirmation
.     di "F-test p-value for `i': `p_value', Dependent variable mean: `depvar_mea
> n'"
 15. }

Linear regression                               Number of obs     =        257
                                                F(4, 93)          =       3.47
                                                Prob > F          =     0.0109
                                                R-squared         =     0.0362
                                                Root MSE          =     .98758

                                   (Std. err. adjusted for 94 clusters in bgy)
------------------------------------------------------------------------------
             |               Robust
      effort | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
 psm_z_wmiss |   .1517267   .0690946     2.20   0.031     .0145184     .288935
  ds_z_wmiss |  -.1142889   .0689833    -1.66   0.101    -.2512761    .0226983
grit_z_wmiss |   .1207405   .0638771     1.89   0.062    -.0061068    .2475878
 bfi_z_wmiss |  -.1031896   .0663343    -1.56   0.123    -.2349164    .0285371
       _cons |   1.997042   .0648751    30.78   0.000     1.868212    2.125871
------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    3.42
            Prob > F =    0.0204

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
      effort |        257    1.996109    .9980373         -2          3
Table_A8.tex
Table_A8.xls
dir : seeout
F-test p-value for effort: .02, Dependent variable mean: 2

Linear regression                               Number of obs     =        257
                                                F(4, 93)          =       2.31
                                                Prob > F          =     0.0635
                                                R-squared         =     0.0311
                                                Root MSE          =     .94962

                                   (Std. err. adjusted for 94 clusters in bgy)
------------------------------------------------------------------------------
             |               Robust
    reliable | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
 psm_z_wmiss |   .1990931   .0797965     2.50   0.014     .0406331    .3575532
  ds_z_wmiss |  -.0734582   .0661858    -1.11   0.270    -.2048901    .0579738
grit_z_wmiss |   .0312667   .0638762     0.49   0.626    -.0955787    .1581121
 bfi_z_wmiss |  -.1090484   .0723854    -1.51   0.135    -.2527914    .0346947
       _cons |   2.040788   .0634529    32.16   0.000     1.914784    2.166793
------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    2.46
            Prob > F =    0.0677

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    reliable |        257    2.042802    .9571466         -2          3
Table_A8.tex
Table_A8.xls
dir : seeout
F-test p-value for reliable: .068, Dependent variable mean: 2.04

Linear regression                               Number of obs     =        256
                                                F(4, 93)          =       2.37
                                                Prob > F          =     0.0578
                                                R-squared         =     0.0367
                                                Root MSE          =     1.0797

                                   (Std. err. adjusted for 94 clusters in bgy)
------------------------------------------------------------------------------
             |               Robust
  responsive | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
 psm_z_wmiss |   .1449303   .0776851     1.87   0.065    -.0093369    .2991975
  ds_z_wmiss |   -.178796   .0798247    -2.24   0.027     -.337312   -.0202799
grit_z_wmiss |  -.1117804   .0700606    -1.60   0.114    -.2509068    .0273461
 bfi_z_wmiss |   .0392372   .0892684     0.44   0.661    -.1380322    .2165065
       _cons |   1.841065   .0755463    24.37   0.000     1.691045    1.991085
------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    3.16
            Prob > F =    0.0282

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  responsive |        256     1.84375     1.09141         -3          3
Table_A8.tex
Table_A8.xls
dir : seeout
F-test p-value for responsive: .028, Dependent variable mean: 1.84

Linear regression                               Number of obs     =        248
                                                F(4, 93)          =       2.11
                                                Prob > F          =     0.0862
                                                R-squared         =     0.0298
                                                Root MSE          =     1.1769

                                   (Std. err. adjusted for 94 clusters in bgy)
------------------------------------------------------------------------------
             |               Robust
  experience | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
 psm_z_wmiss |    .252752   .0961629     2.63   0.010     .0617915    .4437124
  ds_z_wmiss |   -.057527   .0822141    -0.70   0.486     -.220788     .105734
grit_z_wmiss |  -.1420848   .1032949    -1.38   0.172     -.347208    .0630384
 bfi_z_wmiss |  -.0292347   .1131063    -0.26   0.797    -.2538414    .1953719
       _cons |    1.72792   .0869626    19.87   0.000      1.55523    1.900611
------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    2.77
            Prob > F =    0.0460

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  experience |        248    1.729839    1.185095         -3          3
Table_A8.tex
Table_A8.xls
dir : seeout
F-test p-value for experience: .046, Dependent variable mean: 1.73

Linear regression                               Number of obs     =        251
                                                F(4, 92)          =       2.63
                                                Prob > F          =     0.0393
                                                R-squared         =     0.0344
                                                Root MSE          =     1.1278

                                   (Std. err. adjusted for 93 clusters in bgy)
------------------------------------------------------------------------------
             |               Robust
    creative | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
 psm_z_wmiss |   .2126049   .0963376     2.21   0.030       .02127    .4039397
  ds_z_wmiss |  -.1133121   .0803763    -1.41   0.162    -.2729463    .0463221
grit_z_wmiss |  -.0471967   .0834034    -0.57   0.573     -.212843    .1184497
 bfi_z_wmiss |   .0289889   .0956244     0.30   0.762    -.1609295    .2189072
       _cons |   1.634488   .0810037    20.18   0.000     1.473607    1.795368
------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    2.29
            Prob > F =    0.0834

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    creative |        251     1.63745    1.138434         -2          3
Table_A8.tex
Table_A8.xls
dir : seeout
F-test p-value for creative: .083, Dependent variable mean: 1.64

Linear regression                               Number of obs     =        252
                                                F(4, 93)          =       1.70
                                                Prob > F          =     0.1577
                                                R-squared         =     0.0414
                                                Root MSE          =     .98415

                                   (Std. err. adjusted for 94 clusters in bgy)
------------------------------------------------------------------------------
             |               Robust
 trustworthy | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
 psm_z_wmiss |   .2329055   .0923641     2.52   0.013     .0494887    .4163223
  ds_z_wmiss |  -.1000364   .0815721    -1.23   0.223    -.2620224    .0619496
grit_z_wmiss |  -.1426687   .0970922    -1.47   0.145    -.3354745    .0501371
 bfi_z_wmiss |  -.0575308   .0771718    -0.75   0.458    -.2107787     .095717
       _cons |   2.146643   .0740984    28.97   0.000     1.999498    2.293788
------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    2.22
            Prob > F =    0.0905

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
 trustworthy |        252    2.146825    .9971423         -3          3
Table_A8.tex
Table_A8.xls
dir : seeout
F-test p-value for trustworthy: .09, Dependent variable mean: 2.15

Linear regression                               Number of obs     =        250
                                                F(4, 93)          =       1.25
                                                Prob > F          =     0.2965
                                                R-squared         =     0.0232
                                                Root MSE          =     .91261

                                   (Std. err. adjusted for 94 clusters in bgy)
------------------------------------------------------------------------------
             |               Robust
    approach | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
 psm_z_wmiss |   .1579902      .0774     2.04   0.044     .0042892    .3116911
  ds_z_wmiss |  -.0551216    .079921    -0.69   0.492    -.2138288    .1035856
grit_z_wmiss |  -.0942944   .0717224    -1.31   0.192    -.2367208     .048132
 bfi_z_wmiss |  -.0759614    .069565    -1.09   0.278    -.2141036    .0621809
       _cons |   2.219742   .0628086    35.34   0.000     2.095017    2.344468
------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    1.63
            Prob > F =    0.1868

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    approach |        250        2.22    .9159453         -1          3
Table_A8.tex
Table_A8.xls
dir : seeout
F-test p-value for approach: .187, Dependent variable mean: 2.22

Linear regression                               Number of obs     =        250
                                                F(4, 93)          =       2.65
                                                Prob > F          =     0.0382
                                                R-squared         =     0.0368
                                                Root MSE          =     .96872

                                   (Std. err. adjusted for 94 clusters in bgy)
------------------------------------------------------------------------------
             |               Robust
   confident | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
 psm_z_wmiss |   .1724239    .069775     2.47   0.015     .0338645    .3109833
  ds_z_wmiss |  -.1673686   .0666214    -2.51   0.014    -.2996656   -.0350717
grit_z_wmiss |  -.0500955   .0641064    -0.78   0.437    -.1773981    .0772072
 bfi_z_wmiss |  -.0725211   .0729312    -0.99   0.323     -.217348    .0723058
       _cons |   2.075576   .0625677    33.17   0.000     1.951329    2.199823
------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    3.40
            Prob > F =    0.0211

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   confident |        250       2.072     .979107         -1          3
Table_A8.tex
Table_A8.xls
dir : seeout
F-test p-value for confident: .021, Dependent variable mean: 2.07

Linear regression                               Number of obs     =        242
                                                F(4, 92)          =       4.75
                                                Prob > F          =     0.0016
                                                R-squared         =     0.0383
                                                Root MSE          =     1.0908

                                   (Std. err. adjusted for 93 clusters in bgy)
------------------------------------------------------------------------------
             |               Robust
     empathy | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
 psm_z_wmiss |   .1700133   .0925566     1.84   0.069    -.0138121    .3538388
  ds_z_wmiss |  -.1937574   .0647934    -2.99   0.004    -.3224428    -.065072
grit_z_wmiss |    .076153   .0758213     1.00   0.318    -.0744346    .2267406
 bfi_z_wmiss |  -.1269835   .0864147    -1.47   0.145    -.2986105    .0446435
       _cons |   1.863298   .0705202    26.42   0.000     1.723238    2.003357
------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    6.28
            Prob > F =    0.0006

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
     empathy |        242    1.859504    1.103038         -3          3
Table_A8.tex
Table_A8.xls
dir : seeout
F-test p-value for empathy: .001, Dependent variable mean: 1.86

Linear regression                               Number of obs     =        248
                                                F(4, 92)          =       2.90
                                                Prob > F          =     0.0261
                                                R-squared         =     0.0303
                                                Root MSE          =     .93778

                                   (Std. err. adjusted for 93 clusters in bgy)
------------------------------------------------------------------------------
             |               Robust
     overall | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
-------------+----------------------------------------------------------------
 psm_z_wmiss |   .1936238   .0645659     3.00   0.003     .0653904    .3218573
  ds_z_wmiss |  -.0914608   .0624682    -1.46   0.147     -.215528    .0326065
grit_z_wmiss |  -.0314839   .0647036    -0.49   0.628    -.1599908     .097023
 bfi_z_wmiss |  -.0338754   .0792204    -0.43   0.670     -.191214    .1234632
       _cons |   2.080259   .0657389    31.64   0.000     1.949696    2.210822
------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    2.99
            Prob > F =    0.0351

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
     overall |        248    2.080645    .9445927         -2          3
Table_A8.tex
Table_A8.xls
dir : seeout
F-test p-value for overall: .035, Dependent variable mean: 2.08

. 
. 
. ************
. * Table A9 *
. ************
. 
. foreach i in effort reliable responsive experience creative trustworthy approac
> h confident empathy overall {
  2. 
.     // Run the regression
.     reg `i' psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss ///
>     $controls_officer $controls_bgy_respondents $controls_bgy  $controls_junior
> , vce(cl bgy)
  3.     
.     // Perform the F-test
.     test psm_z_wmiss = ds_z_wmiss = grit_z_wmiss = bfi_z_wmiss
  4.     
.     // Capture the p-value from the F-test and round it to 3 decimal points
.     local p_value = round(r(p), 0.001)
  5.     
.     // Calculate the mean of the dependent variable and round it to 2 decimal p
> oints
.     sum `i'
  6.     local depvar_mean = round(r(mean), 0.01)
  7.     
.     // Store the estimates for this regression
.     estimates store reg_`i'
  8. 
.     // Output the regression table, only keeping the specified variables, hidin
> g the constant, and using labels
.     if "`i'" == "effort" {
  9.         outreg2 [reg_`i'] using "Table_A9.xls", replace tex dec(3) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 10.     }
 11.     else {
 12.         outreg2 [reg_`i'] using "Table_A9.xls", append tex dec(3) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 13.     }
 14. 
.     // Optionally display the rounded p-value and dependent variable mean in th
> e console for confirmation
.     di "F-test p-value for `i': `p_value', Dependent variable mean: `depvar_mea
> n'"
 15. }

Linear regression                               Number of obs     =        234
                                                F(37, 86)         =      12.58
                                                Prob > F          =     0.0000
                                                R-squared         =     0.2129
                                                Root MSE          =     .96295

                                     (Std. err. adjusted for 87 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
        effort | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1171562   .0704195     1.66   0.100    -.0228332    .2571456
    ds_z_wmiss |  -.1234518   .0639834    -1.93   0.057    -.2506466    .0037431
  grit_z_wmiss |    .239221    .067942     3.52   0.001     .1041568    .3742852
   bfi_z_wmiss |  -.0914099   .0818806    -1.12   0.267    -.2541831    .0713634
        female |  -.2635386   .2587051    -1.02   0.311    -.7778274    .2507502
           age |  -.0116717   .0256978    -0.45   0.651    -.0627572    .0394138
  years_served |   .0056196   .0224328     0.25   0.803    -.0389754    .0502146
        rank_m |   .0022457   .0776653     0.03   0.977    -.1521478    .1566392
         educ1 |   .7397461   .1719274     4.30   0.000     .3979658    1.081526
         educ2 |          0  (omitted)
         educ3 |  -.1160109   .1850047    -0.63   0.532     -.483788    .2517663
       captain |  -.0350101   .2287459    -0.15   0.879    -.4897418    .4197216
       kagawad |  -.1678893   .1751198    -0.96   0.340    -.5160159    .1802372
    chieftanod |          0  (omitted)
         age_e |  -.0041713      .0103    -0.40   0.686    -.0246471    .0163044
   education_e |  -.0215116   .0695469    -0.31   0.758    -.1597663     .116743
    employed_e |    .087453   .0447488     1.95   0.054    -.0015047    .1764107
      income_e |  -3.87e-07   1.72e-06    -0.23   0.822    -3.80e-06    3.03e-06
reside_years_e |   .0038369   .0057474     0.67   0.506    -.0075886    .0152624
        male_e |   .3321417   .2831319     1.17   0.244    -.2307059    .8949894
 assets_roof_e |  -.0065664   .0070812    -0.93   0.356    -.0206433    .0075106
years_served_e |   .0156127   .0127013     1.23   0.222    -.0096366     .040862
c10_population |    .000226   .0001271     1.78   0.079    -.0000266    .0004786
      c10_male |   .6421793   5.197722     0.12   0.902     -9.69055    10.97491
    c10_hhsize |   .0641493   .2078901     0.31   0.758    -.3491226    .4774211
       c10_ofw |  -1.064012   6.023319    -0.18   0.860    -13.03797    10.90995
 c10_education |   .9963384   .4423497     2.25   0.027     .1169763      1.8757
  c10_age18_39 |  -1.052527   1.914559    -0.55   0.584    -4.858544     2.75349
 c10_ms_single |  -3.045879   3.212501    -0.95   0.346     -9.43212    3.340363
  c10_catholic |  -.2516959   1.905994    -0.13   0.895    -4.040686    3.537294
        c10_ip |   12.34799    6.47654     1.91   0.060    -.5269461    25.22293
 c10_home_good |  -.7765997   5.235468    -0.15   0.882    -11.18437    9.631166
      npa_2015 |  -.0628098   .1446944    -0.43   0.665    -.3504527    .2248331
      dist_mps |    .017048   .0250529     0.68   0.498    -.0327555    .0668514
  acrime_num_m |  -.0102515   .0099167    -1.03   0.304    -.0299652    .0094622
  psm2_z_wmiss |     .09081   .0807646     1.12   0.264    -.0697447    .2513646
   ds2_z_wmiss |   .2510719    .070667     3.55   0.001     .1105906    .3915531
 grit2_z_wmiss |  -.0253687   .0908218    -0.28   0.781    -.2059164    .1551791
  bfi2_z_wmiss |  -.2349673   .1100212    -2.14   0.036    -.4536822   -.0162523
         _cons |   1.323715   5.154459     0.26   0.798     -8.92301    11.57044
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    86) =    5.55
            Prob > F =    0.0016

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
      effort |        257    1.996109    .9980373         -2          3
Table_A9.tex
Table_A9.xls
dir : seeout
F-test p-value for effort: .002, Dependent variable mean: 2

Linear regression                               Number of obs     =        234
                                                F(37, 86)         =       2.87
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1815
                                                Root MSE          =     .93338

                                     (Std. err. adjusted for 87 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
      reliable | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1777456   .0857625     2.07   0.041     .0072554    .3482357
    ds_z_wmiss |  -.0831884   .0682436    -1.22   0.226    -.2188521    .0524753
  grit_z_wmiss |    .083008   .0726617     1.14   0.256    -.0614388    .2274547
   bfi_z_wmiss |  -.1269636   .0884931    -1.43   0.155    -.3028821    .0489548
        female |  -.1445452   .2718264    -0.53   0.596    -.6849183    .3958278
           age |  -.0275075   .0220096    -1.25   0.215    -.0712611    .0162461
  years_served |  -.0109735   .0194257    -0.56   0.574    -.0495905    .0276436
        rank_m |   .1267856   .0719623     1.76   0.082    -.0162707    .2698419
         educ1 |   .5626441    .440047     1.28   0.204    -.3121404    1.437429
         educ2 |          0  (omitted)
         educ3 |   .0295025    .177195     0.17   0.868    -.3227496    .3817546
       captain |  -.2294445    .210142    -1.09   0.278     -.647193     .188304
       kagawad |  -.2122741   .1469098    -1.44   0.152    -.5043211    .0797729
    chieftanod |          0  (omitted)
         age_e |  -.0016579   .0092395    -0.18   0.858    -.0200255    .0167097
   education_e |  -.0002681   .0664369    -0.00   0.997    -.1323404    .1318041
    employed_e |   .1171201   .0467446     2.51   0.014     .0241949    .2100453
      income_e |   1.69e-06   1.85e-06     0.91   0.363    -1.99e-06    5.37e-06
reside_years_e |   .0055485   .0057908     0.96   0.341    -.0059632    .0170602
        male_e |   .2308789   .2503386     0.92   0.359    -.2667778    .7285355
 assets_roof_e |  -.0043384   .0086754    -0.50   0.618    -.0215846    .0129077
years_served_e |   .0189504   .0122777     1.54   0.126     -.005457    .0433577
c10_population |   .0000178   .0001583     0.11   0.911    -.0002968    .0003324
      c10_male |  -1.451201   5.070774    -0.29   0.775    -11.53157    8.629164
    c10_hhsize |    .117859    .211722     0.56   0.579    -.3030303    .5387483
       c10_ofw |  -7.845688   6.567987    -1.19   0.236    -20.90241    5.211038
 c10_education |   .5314642   .4382831     1.21   0.229    -.3398137    1.402742
  c10_age18_39 |  -1.368526    1.83579    -0.75   0.458    -5.017956    2.280903
 c10_ms_single |  -.0966726   3.359694    -0.03   0.977    -6.775523    6.582178
  c10_catholic |  -1.655072   1.716657    -0.96   0.338    -5.067673    1.757528
        c10_ip |   6.560195   7.654554     0.86   0.394    -8.656554    21.77694
 c10_home_good |    2.33471   5.366581     0.44   0.665    -8.333701    13.00312
      npa_2015 |  -.0462857   .1532184    -0.30   0.763    -.3508737    .2583024
      dist_mps |   .0199715   .0241294     0.83   0.410    -.0279961    .0679391
  acrime_num_m |  -.0103594   .0108008    -0.96   0.340    -.0318306    .0111119
  psm2_z_wmiss |  -.0236238   .0864192    -0.27   0.785    -.1954195    .1481719
   ds2_z_wmiss |   .1629801   .0715211     2.28   0.025     .0208008    .3051594
 grit2_z_wmiss |  -.0137333   .0887596    -0.15   0.877    -.1901815    .1627149
  bfi2_z_wmiss |  -.0871945   .1006507    -0.87   0.389    -.2872815    .1128926
         _cons |   1.487794    5.19603     0.29   0.775    -8.841571    11.81716
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    86) =    2.71
            Prob > F =    0.0503

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    reliable |        257    2.042802    .9571466         -2          3
Table_A9.tex
Table_A9.xls
dir : seeout
F-test p-value for reliable: .05, Dependent variable mean: 2.04

Linear regression                               Number of obs     =        233
                                                F(37, 86)         =       6.46
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1645
                                                Root MSE          =     1.0853

                                     (Std. err. adjusted for 87 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
    responsive | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0082833   .0836956     0.10   0.921     -.158098    .1746647
    ds_z_wmiss |  -.2172374   .0661668    -3.28   0.001    -.3487727   -.0857022
  grit_z_wmiss |  -.0190337   .0840779    -0.23   0.821     -.186175    .1481076
   bfi_z_wmiss |   .0527882   .1082465     0.49   0.627    -.1623987     .267975
        female |  -.0911419   .2850291    -0.32   0.750    -.6577609    .4754771
           age |  -.0089246   .0251398    -0.35   0.723    -.0589009    .0410517
  years_served |   .0152712   .0203402     0.75   0.455    -.0251638    .0557062
        rank_m |  -.1674533   .0835269    -2.00   0.048    -.3334993   -.0014073
         educ1 |   .8893763   .3317648     2.68   0.009     .2298498    1.548903
         educ2 |          0  (omitted)
         educ3 |  -.1836222   .2477063    -0.74   0.461     -.676046    .3088016
       captain |  -.0776652     .26393    -0.29   0.769    -.6023407    .4470104
       kagawad |  -.0188993    .189799    -0.10   0.921    -.3962072    .3584087
    chieftanod |          0  (omitted)
         age_e |  -.0066746   .0106526    -0.63   0.533    -.0278513    .0145021
   education_e |   .0131876   .0679177     0.19   0.847    -.1218283    .1482035
    employed_e |    .098678   .0649018     1.52   0.132    -.0303425    .2276985
      income_e |   9.99e-07   2.47e-06     0.40   0.687    -3.92e-06    5.92e-06
reside_years_e |   .0073645    .007195     1.02   0.309    -.0069387    .0216677
        male_e |   .2148318   .2596955     0.83   0.410    -.3014258    .7310894
 assets_roof_e |   -.012238   .0037317    -3.28   0.002    -.0196565   -.0048196
years_served_e |   .0171961   .0118705     1.45   0.151    -.0064016    .0407938
c10_population |   .0001255   .0002262     0.56   0.580    -.0003241    .0005752
      c10_male |  -8.094314   6.069389    -1.33   0.186    -20.15986    3.971233
    c10_hhsize |   .0900393   .2418847     0.37   0.711    -.3908116    .5708902
       c10_ofw |   4.725013   10.46992     0.45   0.653    -16.08851    25.53853
 c10_education |   .2391913   .5947543     0.40   0.689    -.9431412    1.421524
  c10_age18_39 |   .7233135   2.442185     0.30   0.768     -4.13159    5.578217
 c10_ms_single |  -7.393322   3.381396    -2.19   0.031    -14.11531   -.6713294
  c10_catholic |   .0845991   2.326199     0.04   0.971    -4.539732    4.708931
        c10_ip |   6.825565   7.096776     0.96   0.339    -7.282358    20.93349
 c10_home_good |  -11.12986   5.963952    -1.87   0.065     -22.9858    .7260826
      npa_2015 |   .1967339   .1591522     1.24   0.220    -.1196501    .5131179
      dist_mps |  -.0114987   .0315594    -0.36   0.716    -.0742368    .0512393
  acrime_num_m |  -.0059387   .0094739    -0.63   0.532    -.0247721    .0128947
  psm2_z_wmiss |    .040058   .1078637     0.37   0.711    -.1743679    .2544839
   ds2_z_wmiss |   .1488537    .074043     2.01   0.048     .0016611    .2960463
 grit2_z_wmiss |  -.1938481   .1217189    -1.59   0.115    -.4358172    .0481211
  bfi2_z_wmiss |  -.0676945   .1152166    -0.59   0.558    -.2967375    .1613486
         _cons |    13.3599   6.438401     2.08   0.041     .5607794    26.15901
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    86) =    3.11
            Prob > F =    0.0305

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  responsive |        256     1.84375     1.09141         -3          3
Table_A9.tex
Table_A9.xls
dir : seeout
F-test p-value for responsive: .03, Dependent variable mean: 1.84

Linear regression                               Number of obs     =        225
                                                F(37, 86)         =      21.35
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1906
                                                Root MSE          =     1.1566

                                     (Std. err. adjusted for 87 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
    experience | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2031279   .1122111     1.81   0.074    -.0199403    .4261961
    ds_z_wmiss |  -.1736397   .0842941    -2.06   0.042    -.3412108   -.0060685
  grit_z_wmiss |  -.0780588   .1049376    -0.74   0.459    -.2866678    .1305502
   bfi_z_wmiss |  -.0560302   .1144478    -0.49   0.626    -.2835449    .1714846
        female |   .1485174   .2976635     0.50   0.619    -.4432181    .7402529
           age |  -.0054956   .0259677    -0.21   0.833    -.0571178    .0461265
  years_served |   .0072343   .0241181     0.30   0.765    -.0407108    .0551794
        rank_m |  -.0205541   .1028038    -0.20   0.842    -.2249213     .183813
         educ1 |   1.237315   .3161452     3.91   0.000     .6088388    1.865791
         educ2 |          0  (omitted)
         educ3 |   .2636484   .2518772     1.05   0.298    -.2370669    .7643637
       captain |   .0793273    .251351     0.32   0.753     -.420342    .5789967
       kagawad |  -.1613112   .2195651    -0.73   0.465    -.5977923    .2751698
    chieftanod |          0  (omitted)
         age_e |  -.0110396   .0124464    -0.89   0.378    -.0357823    .0137031
   education_e |  -.0826508   .0813104    -1.02   0.312    -.2442905    .0789889
    employed_e |  -.0236281   .0791122    -0.30   0.766    -.1808979    .1336418
      income_e |   2.18e-07   2.64e-06     0.08   0.935    -5.04e-06    5.47e-06
reside_years_e |   .0104004   .0077673     1.34   0.184    -.0050405    .0258412
        male_e |    .141454   .3552636     0.40   0.691    -.5647867    .8476946
 assets_roof_e |  -.0089127   .0041545    -2.15   0.035    -.0171717   -.0006538
years_served_e |     .00527   .0148112     0.36   0.723    -.0241736    .0347136
c10_population |   .0003123   .0002449     1.28   0.206    -.0001745    .0007991
      c10_male |   .9283121    7.88064     0.12   0.907    -14.73788    16.59451
    c10_hhsize |  -.0530447   .3097752    -0.17   0.864    -.6688574     .562768
       c10_ofw |  -1.378133   8.613439    -0.16   0.873    -18.50108    15.74482
 c10_education |   1.015985   .6418102     1.58   0.117    -.2598915    2.291861
  c10_age18_39 |  -1.750303   2.272582    -0.77   0.443    -6.268047    2.767441
 c10_ms_single |  -7.542364   4.427747    -1.70   0.092    -16.34443    1.259706
  c10_catholic |    1.13452   2.886162     0.39   0.695    -4.602979    6.872019
        c10_ip |   9.141694   8.499534     1.08   0.285    -7.754821    26.03821
 c10_home_good |  -7.065585   7.744156    -0.91   0.364    -22.46046    8.329287
      npa_2015 |   .1321989   .2225888     0.59   0.554    -.3102929    .5746908
      dist_mps |  -.0469533   .0342476    -1.37   0.174    -.1150353    .0211286
  acrime_num_m |  -.0035442   .0098916    -0.36   0.721    -.0232082    .0161197
  psm2_z_wmiss |  -.0352126   .1074855    -0.33   0.744    -.2488867    .1784615
   ds2_z_wmiss |   .1924037    .105544     1.82   0.072    -.0174108    .4022182
 grit2_z_wmiss |  -.2044569   .1386585    -1.47   0.144     -.480101    .0711872
  bfi2_z_wmiss |  -.0513386   .1473049    -0.35   0.728     -.344171    .2414938
         _cons |   4.668291   7.426376     0.63   0.531    -10.09486    19.43144
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    86) =    2.58
            Prob > F =    0.0587

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  experience |        248    1.729839    1.185095         -3          3
Table_A9.tex
Table_A9.xls
dir : seeout
F-test p-value for experience: .059, Dependent variable mean: 1.73

Linear regression                               Number of obs     =        228
                                                F(37, 85)         =      11.86
                                                Prob > F          =     0.0000
                                                R-squared         =     0.2415
                                                Root MSE          =     1.0666

                                     (Std. err. adjusted for 86 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
      creative | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1343978   .0994485     1.35   0.180    -.0633325    .3321281
    ds_z_wmiss |  -.1230499   .0814576    -1.51   0.135    -.2850093    .0389096
  grit_z_wmiss |  -.0039489   .0928369    -0.04   0.966    -.1885334    .1806357
   bfi_z_wmiss |   .0159453   .1066108     0.15   0.881    -.1960254     .227916
        female |  -.3657326   .2756603    -1.33   0.188    -.9138191     .182354
           age |  -.0159057     .02063    -0.77   0.443    -.0569237    .0251123
  years_served |   .0033192   .0194474     0.17   0.865    -.0353474    .0419858
        rank_m |  -.0204118   .0866979    -0.24   0.814    -.1927905    .1519668
         educ1 |   1.389132   .2692311     5.16   0.000     .8538286    1.924436
         educ2 |          0  (omitted)
         educ3 |   .1483588   .1802911     0.82   0.413    -.2101082    .5068259
       captain |  -.1296262   .2464482    -0.53   0.600    -.6196312    .3603788
       kagawad |   -.277808   .2242586    -1.24   0.219    -.7236942    .1680781
    chieftanod |          0  (omitted)
         age_e |   -.004046   .0095007    -0.43   0.671    -.0229359     .014844
   education_e |  -.0325663   .0766174    -0.43   0.672    -.1849023    .1197696
    employed_e |   .1288234   .0656961     1.96   0.053    -.0017979    .2594448
      income_e |   2.38e-06   2.06e-06     1.16   0.251    -1.71e-06    6.48e-06
reside_years_e |   .0065831   .0062896     1.05   0.298    -.0059223    .0190885
        male_e |   .2748115   .2912925     0.94   0.348    -.3043559     .853979
 assets_roof_e |  -.0172109   .0035991    -4.78   0.000    -.0243669   -.0100549
years_served_e |  -.0007433   .0176407    -0.04   0.966    -.0358177    .0343311
c10_population |   .0000763   .0001872     0.41   0.685    -.0002959    .0004484
      c10_male |  -5.241505   6.712379    -0.78   0.437    -18.58751    8.104503
    c10_hhsize |  -.2459436   .2574898    -0.96   0.342    -.7579023    .2660151
       c10_ofw |  -5.663675   6.983465    -0.81   0.420    -19.54867    8.221324
 c10_education |  -.0230624   .5350233    -0.04   0.966    -1.086832    1.040707
  c10_age18_39 |  -1.273759   2.347315    -0.54   0.589     -5.94085    3.393332
 c10_ms_single |   .5835613   4.027631     0.14   0.885    -7.424448     8.59157
  c10_catholic |   -6.27225   2.032684    -3.09   0.003    -10.31377   -2.230731
        c10_ip |  -4.206836   6.872528    -0.61   0.542    -17.87126    9.457591
 c10_home_good |  -2.622723   7.171006    -0.37   0.715     -16.8806    11.63516
      npa_2015 |  -.1354138   .1576305    -0.86   0.393    -.4488254    .1779979
      dist_mps |   .0293612   .0272235     1.08   0.284    -.0247665    .0834888
  acrime_num_m |  -.0066814    .011516    -0.58   0.563    -.0295782    .0162154
  psm2_z_wmiss |  -.1866294   .0935308    -2.00   0.049    -.3725937   -.0006652
   ds2_z_wmiss |   .2367697   .0765116     3.09   0.003     .0846441    .3888952
 grit2_z_wmiss |  -.1306066   .1187153    -1.10   0.274    -.3666444    .1054313
  bfi2_z_wmiss |  -.0743935   .1195847    -0.62   0.536    -.3121598    .1633728
         _cons |   13.20767   6.686334     1.98   0.051    -.0865588    26.50189
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    85) =    1.34
            Prob > F =    0.2681

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    creative |        251     1.63745    1.138434         -2          3
Table_A9.tex
Table_A9.xls
dir : seeout
F-test p-value for creative: .268, Dependent variable mean: 1.64

Linear regression                               Number of obs     =        229
                                                F(37, 86)         =       2.86
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1656
                                                Root MSE          =     .99729

                                     (Std. err. adjusted for 87 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
   trustworthy | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1890081    .091254     2.07   0.041     .0076011    .3704151
    ds_z_wmiss |  -.1103901   .0751433    -1.47   0.145      -.25977    .0389898
  grit_z_wmiss |  -.1244899    .115175    -1.08   0.283    -.3534502    .1044704
   bfi_z_wmiss |  -.0530525   .0839318    -0.63   0.529    -.2199035    .1137984
        female |  -.1339371   .2627543    -0.51   0.612    -.6562753    .3884011
           age |  -.0015654   .0267898    -0.06   0.954    -.0548217     .051691
  years_served |  -.0064979   .0249326    -0.26   0.795    -.0560622    .0430664
        rank_m |   .0228884   .0858093     0.27   0.790    -.1476948    .1934716
         educ1 |   .6132566   .2158708     2.84   0.006     .1841197    1.042393
         educ2 |          0  (omitted)
         educ3 |   .2062694   .2372093     0.87   0.387    -.2652871    .6778258
       captain |   .1060411   .2247792     0.47   0.638    -.3408051    .5528873
       kagawad |   -.005059   .1658549    -0.03   0.976    -.3347675    .3246495
    chieftanod |          0  (omitted)
         age_e |  -.0104444   .0105581    -0.99   0.325    -.0314332    .0105444
   education_e |  -.0639977   .0685309    -0.93   0.353    -.2002326    .0722373
    employed_e |    .106705   .0505615     2.11   0.038     .0061922    .2072179
      income_e |   1.51e-06   1.90e-06     0.79   0.430    -2.27e-06    5.28e-06
reside_years_e |    .005586     .00597     0.94   0.352    -.0062819    .0174539
        male_e |  -.0869406   .2539133    -0.34   0.733    -.5917034    .4178223
 assets_roof_e |  -.0062204   .0063206    -0.98   0.328    -.0187854    .0063445
years_served_e |   .0223903   .0133472     1.68   0.097     -.004143    .0489236
c10_population |  -.0000764   .0001747    -0.44   0.663    -.0004237    .0002709
      c10_male |  -10.76972   6.649551    -1.62   0.109    -23.98859     2.44915
    c10_hhsize |   .1767608   .2350027     0.75   0.454    -.2904092    .6439307
       c10_ofw |  -3.373006   6.984444    -0.48   0.630    -17.25762    10.51161
 c10_education |   .5673142   .5144463     1.10   0.273    -.4553711        1.59
  c10_age18_39 |   2.221467   2.170346     1.02   0.309    -2.093037    6.535971
 c10_ms_single |   -.882795     3.8165    -0.23   0.818    -8.469747    6.704157
  c10_catholic |   1.656891   2.221548     0.75   0.458    -2.759401    6.073182
        c10_ip |   12.31543   6.986359     1.76   0.081    -1.572995    26.20385
 c10_home_good |   3.106609   7.030439     0.44   0.660    -10.86944    17.08266
      npa_2015 |   .1433631   .1944044     0.74   0.463       -.2431    .5298262
      dist_mps |   .0598031   .0273344     2.19   0.031      .005464    .1141421
  acrime_num_m |  -.0111769   .0099169    -1.13   0.263    -.0308911    .0085372
  psm2_z_wmiss |   -.071649   .0947237    -0.76   0.451    -.2599535    .1166554
   ds2_z_wmiss |   .1298888   .0896815     1.45   0.151    -.0483922    .3081698
 grit2_z_wmiss |  -.0386064   .1087707    -0.35   0.724    -.2548355    .1776226
  bfi2_z_wmiss |  -.0303363   .1150755    -0.26   0.793    -.2590988    .1984261
         _cons |   1.898296   6.468936     0.29   0.770    -10.96152    14.75812
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    86) =    2.03
            Prob > F =    0.1153

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
 trustworthy |        252    2.146825    .9971423         -3          3
Table_A9.tex
Table_A9.xls
dir : seeout
F-test p-value for trustworthy: .115, Dependent variable mean: 2.15

Linear regression                               Number of obs     =        227
                                                F(37, 86)         =       3.54
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1811
                                                Root MSE          =     .89457

                                     (Std. err. adjusted for 87 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
      approach | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1426466   .0753029     1.89   0.062    -.0070507    .2923439
    ds_z_wmiss |  -.0868766   .0675043    -1.29   0.202    -.2210706    .0473175
  grit_z_wmiss |  -.0375113   .0728491    -0.51   0.608    -.1823305    .1073079
   bfi_z_wmiss |  -.0444605   .0772125    -0.58   0.566    -.1979539    .1090328
        female |  -.0554153    .239422    -0.23   0.818    -.5313705    .4205398
           age |  -.0138475   .0218599    -0.63   0.528    -.0573035    .0296086
  years_served |   .0142587    .020568     0.69   0.490     -.026629    .0551465
        rank_m |   .0259076   .0787142     0.33   0.743    -.1305711    .1823864
         educ1 |   .5314966   .2074043     2.56   0.012     .1191905    .9438027
         educ2 |          0  (omitted)
         educ3 |   .0835235   .2207565     0.38   0.706    -.3553259     .522373
       captain |  -.2937266   .1944786    -1.51   0.135    -.6803372    .0928841
       kagawad |  -.0447307   .1390039    -0.32   0.748    -.3210613    .2315999
    chieftanod |          0  (omitted)
         age_e |  -.0040014   .0086168    -0.46   0.644    -.0211309    .0131282
   education_e |   .0338415   .0616675     0.55   0.585    -.0887495    .1564326
    employed_e |    .086339   .0451951     1.91   0.059    -.0035059     .176184
      income_e |   4.35e-06   2.22e-06     1.96   0.054    -6.80e-08    8.76e-06
reside_years_e |   .0103878   .0053743     1.93   0.057    -.0002959    .0210716
        male_e |  -.1037726   .2430432    -0.43   0.670    -.5869266    .3793813
 assets_roof_e |  -.0161782   .0078399    -2.06   0.042    -.0317635   -.0005929
years_served_e |   .0180488   .0125501     1.44   0.154    -.0068999    .0429975
c10_population |  -.0001461   .0001737    -0.84   0.403    -.0004914    .0001992
      c10_male |  -5.474834   5.191047    -1.05   0.295    -15.79429    4.844626
    c10_hhsize |   .0743598   .2063472     0.36   0.719    -.3358449    .4845644
       c10_ofw |  -4.011112   5.639492    -0.71   0.479    -15.22205    7.199828
 c10_education |   .6521676   .4494018     1.45   0.150    -.2412137    1.545549
  c10_age18_39 |   2.064715   1.836132     1.12   0.264    -1.585395    5.714826
 c10_ms_single |  -.8022641   3.457054    -0.23   0.817     -7.67466    6.070131
  c10_catholic |   1.128763   1.853653     0.61   0.544    -2.556176    4.813703
        c10_ip |   14.21785   6.393655     2.22   0.029     1.507689    26.92802
 c10_home_good |   3.188936   5.996094     0.53   0.596    -8.730904    15.10878
      npa_2015 |   .1187346   .1562065     0.76   0.449    -.1917937    .4292628
      dist_mps |    .028271    .022242     1.27   0.207    -.0159446    .0724866
  acrime_num_m |  -.0141271   .0090383    -1.56   0.122    -.0320947    .0038404
  psm2_z_wmiss |   .0306838   .0757978     0.40   0.687    -.1199974    .1813649
   ds2_z_wmiss |    .133812    .064036     2.09   0.040     .0065126    .2611114
 grit2_z_wmiss |    .014859   .1012509     0.15   0.884     -.186421    .2161391
  bfi2_z_wmiss |  -.0782545   .1043022    -0.75   0.455    -.2856003    .1290914
         _cons |  -.1246754   5.356082    -0.02   0.981    -10.77221    10.52286
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    86) =    1.64
            Prob > F =    0.1851

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    approach |        250        2.22    .9159453         -1          3
Table_A9.tex
Table_A9.xls
dir : seeout
F-test p-value for approach: .185, Dependent variable mean: 2.22

Linear regression                               Number of obs     =        227
                                                F(37, 86)         =       7.61
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1492
                                                Root MSE          =     .98122

                                     (Std. err. adjusted for 87 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
     confident | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1769482   .0756656     2.34   0.022     .0265299    .3273665
    ds_z_wmiss |   -.182805   .0589757    -3.10   0.003    -.3000448   -.0655652
  grit_z_wmiss |   .0168678   .0695088     0.24   0.809    -.1213112    .1550468
   bfi_z_wmiss |  -.0924219   .0852183    -1.08   0.281    -.2618303    .0769866
        female |  -.0276277   .2552594    -0.11   0.914    -.5350667    .4798113
           age |   .0113992   .0250626     0.45   0.650    -.0384237    .0612221
  years_served |   .0013718   .0224869     0.06   0.951    -.0433306    .0460742
        rank_m |   -.064725   .0795962    -0.81   0.418    -.2229571    .0935071
         educ1 |    .651983   .2178356     2.99   0.004     .2189402    1.085026
         educ2 |          0  (omitted)
         educ3 |  -.0736538   .2154828    -0.34   0.733    -.5020195    .3547119
       captain |  -.0467226   .2359839    -0.20   0.844     -.515843    .4223979
       kagawad |   .0768656   .1730486     0.44   0.658    -.2671436    .4208747
    chieftanod |          0  (omitted)
         age_e |   .0062131   .0089524     0.69   0.490    -.0115836    .0240099
   education_e |  -.0016405   .0578718    -0.03   0.977    -.1166857    .1134048
    employed_e |   .0319862   .0568619     0.56   0.575    -.0810514    .1450238
      income_e |   3.42e-06   2.44e-06     1.40   0.164    -1.42e-06    8.26e-06
reside_years_e |   .0072654   .0058494     1.24   0.218    -.0043629    .0188937
        male_e |    .200546   .2490857     0.81   0.423      -.29462    .6957119
 assets_roof_e |  -.0078009   .0058859    -1.33   0.189    -.0195017    .0038998
years_served_e |   .0033523   .0136717     0.25   0.807    -.0238261    .0305307
c10_population |   .0000739   .0001561     0.47   0.637    -.0002365    .0003842
      c10_male |  -1.378729   4.539868    -0.30   0.762    -10.40369     7.64623
    c10_hhsize |   .2777413   .2166339     1.28   0.203    -.1529126    .7083951
       c10_ofw |  -6.727487   5.866147    -1.15   0.255      -18.389    4.934027
 c10_education |   .7974652   .4373397     1.82   0.072    -.0719374    1.666868
  c10_age18_39 |  -.5686634   1.878163    -0.30   0.763    -4.302328    3.165001
 c10_ms_single |  -3.551985   3.440425    -1.03   0.305    -10.39132    3.287353
  c10_catholic |   .1039163    2.07483     0.05   0.960    -4.020709    4.228542
        c10_ip |   5.301554   5.177425     1.02   0.309    -4.990827    15.59394
 c10_home_good |   .1744209   6.280083     0.03   0.978    -12.30997    12.65881
      npa_2015 |   .0257119   .1693541     0.15   0.880    -.3109528    .3623766
      dist_mps |   .0466667   .0262707     1.78   0.079    -.0055577    .0988911
  acrime_num_m |  -.0108837   .0084338    -1.29   0.200    -.0276496    .0058821
  psm2_z_wmiss |  -.0669686    .076876    -0.87   0.386    -.2197931    .0858558
   ds2_z_wmiss |   .1403709   .0730852     1.92   0.058    -.0049177    .2856595
 grit2_z_wmiss |   -.101731   .0967909    -1.05   0.296    -.2941449    .0906828
  bfi2_z_wmiss |   .0318119   .1037532     0.31   0.760    -.1744427    .2380664
         _cons |   1.068558   5.689478     0.19   0.851    -10.24175    12.37887
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    86) =    4.81
            Prob > F =    0.0038

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   confident |        250       2.072     .979107         -1          3
Table_A9.tex
Table_A9.xls
dir : seeout
F-test p-value for confident: .004, Dependent variable mean: 2.07

Linear regression                               Number of obs     =        219
                                                F(37, 85)         =       4.25
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1588
                                                Root MSE          =     1.1211

                                     (Std. err. adjusted for 86 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
       empathy | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0924801   .1062254     0.87   0.386    -.1187245    .3036846
    ds_z_wmiss |  -.2014598   .0675132    -2.98   0.004    -.3356941   -.0672255
  grit_z_wmiss |   .1783739   .0978058     1.82   0.072    -.0160902    .3728381
   bfi_z_wmiss |  -.1676124    .102086    -1.64   0.104    -.3705867     .035362
        female |   .0204992   .2604477     0.08   0.937    -.4973406     .538339
           age |  -.0063643    .021189    -0.30   0.765    -.0484936     .035765
  years_served |  -.0052261   .0188351    -0.28   0.782    -.0426753     .032223
        rank_m |   -.016499    .129188    -0.13   0.899    -.2733594    .2403614
         educ1 |   .3805331   .2963417     1.28   0.203    -.2086736    .9697398
         educ2 |          0  (omitted)
         educ3 |   .0022779   .2137379     0.01   0.992    -.4226903     .427246
       captain |    .101083   .2893217     0.35   0.728    -.4741661    .6763321
       kagawad |   .0144718   .2554412     0.06   0.955    -.4934139    .5223574
    chieftanod |          0  (omitted)
         age_e |   .0095776   .0121733     0.79   0.434    -.0146261    .0337813
   education_e |   .0464335   .0814077     0.57   0.570    -.1154268    .2082938
    employed_e |   .0558927   .0656898     0.85   0.397    -.0747162    .1865017
      income_e |   1.15e-06   2.61e-06     0.44   0.660    -4.03e-06    6.34e-06
reside_years_e |  -.0003412   .0063594    -0.05   0.957    -.0129853    .0123029
        male_e |   .0342979   .2792912     0.12   0.903    -.5210078    .5896036
 assets_roof_e |  -.0076223   .0050797    -1.50   0.137    -.0177221    .0024775
years_served_e |     .00211   .0162088     0.13   0.897    -.0301174    .0343374
c10_population |   .0004174     .00017     2.45   0.016     .0000793    .0007554
      c10_male |  -5.806259    5.63934    -1.03   0.306    -17.01878    5.406261
    c10_hhsize |   .1101083   .2505825     0.44   0.661    -.3881168    .6083334
       c10_ofw |  -11.05737   6.549861    -1.69   0.095    -24.08025    1.965509
 c10_education |  -.0350873    .594755    -0.06   0.953    -1.217619    1.147445
  c10_age18_39 |   -.821554    1.83958    -0.45   0.656    -4.479131    2.836024
 c10_ms_single |  -1.600821   4.192792    -0.38   0.704    -9.937214    6.735573
  c10_catholic |  -2.050732   2.182683    -0.94   0.350    -6.390489    2.289026
        c10_ip |  -2.707794   5.889981    -0.46   0.647    -14.41865    9.003066
 c10_home_good |  -1.320351   6.363016    -0.21   0.836    -13.97173    11.33103
      npa_2015 |   .0373846   .1745748     0.21   0.831    -.3097169    .3844861
      dist_mps |  -.0083736   .0296275    -0.28   0.778     -.067281    .0505338
  acrime_num_m |  -.0074537   .0122574    -0.61   0.545    -.0318247    .0169173
  psm2_z_wmiss |  -.0554926   .0841568    -0.66   0.511    -.2228188    .1118337
   ds2_z_wmiss |   .2299582   .0881199     2.61   0.011     .0547523    .4051641
 grit2_z_wmiss |  -.1436563   .1200749    -1.20   0.235    -.3823974    .0950848
  bfi2_z_wmiss |  -.0372404   .1018023    -0.37   0.715    -.2396505    .1651698
         _cons |   7.555291   5.239486     1.44   0.153    -2.862211    17.97279
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    85) =    5.09
            Prob > F =    0.0027

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
     empathy |        242    1.859504    1.103038         -3          3
Table_A9.tex
Table_A9.xls
dir : seeout
F-test p-value for empathy: .003, Dependent variable mean: 1.86

Linear regression                               Number of obs     =        225
                                                F(37, 85)         =       7.29
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1909
                                                Root MSE          =     .92142

                                     (Std. err. adjusted for 86 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
       overall | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1128992   .0749016     1.51   0.135    -.0360253    .2618237
    ds_z_wmiss |  -.0781612   .0562785    -1.39   0.169     -.190058    .0337355
  grit_z_wmiss |   .0265557   .0805524     0.33   0.742    -.1336041    .1867154
   bfi_z_wmiss |  -.0316589   .0937312    -0.34   0.736    -.2180216    .1547039
        female |  -.2765545    .242142    -1.14   0.257    -.7579977    .2048886
           age |  -.0315841   .0217785    -1.45   0.151    -.0748855    .0117173
  years_served |  -.0082706   .0191741    -0.43   0.667    -.0463939    .0298527
        rank_m |   .1156636   .0791096     1.46   0.147    -.0416274    .2729547
         educ1 |   .9354726   .1833693     5.10   0.000     .5708854     1.30006
         educ2 |          0  (omitted)
         educ3 |   .1215737   .2279521     0.53   0.595    -.3316562    .5748035
       captain |   -.117937    .220081    -0.54   0.593    -.5555171    .3196431
       kagawad |   -.122892   .1505193    -0.82   0.417    -.4221646    .1763806
    chieftanod |          0  (omitted)
         age_e |   .0012163   .0103575     0.12   0.907    -.0193773    .0218098
   education_e |   .0088684   .0731505     0.12   0.904    -.1365744    .1543111
    employed_e |   .1098607   .0398186     2.76   0.007     .0306906    .1890308
      income_e |   2.40e-06   1.98e-06     1.21   0.228    -1.53e-06    6.33e-06
reside_years_e |   .0056955   .0052999     1.07   0.286    -.0048422    .0162333
        male_e |   .1907832   .2830192     0.67   0.502    -.3719348    .7535011
 assets_roof_e |  -.0066877    .005839    -1.15   0.255    -.0182972    .0049218
years_served_e |   .0129965   .0124055     1.05   0.298    -.0116691     .037662
c10_population |  -2.70e-06   .0001812    -0.01   0.988     -.000363    .0003577
      c10_male |  -5.290125    5.20246    -1.02   0.312    -15.63401     5.05376
    c10_hhsize |    .136834    .225177     0.61   0.545    -.3108782    .5845462
       c10_ofw |   3.510824   7.339906     0.48   0.634    -11.08288    18.10452
 c10_education |   .3671014    .468031     0.78   0.435    -.5634696    1.297672
  c10_age18_39 |   3.080305   2.128724     1.45   0.152    -1.152168    7.312778
 c10_ms_single |   .9924913   3.111493     0.32   0.751    -5.193991    7.178974
  c10_catholic |  -.0181135   2.344218    -0.01   0.994    -4.679046    4.642819
        c10_ip |   10.56417   5.400342     1.96   0.054    -.1731531     21.3015
 c10_home_good |   4.441329    5.06149     0.88   0.383     -5.62227    14.50493
      npa_2015 |   .0142493     .14997     0.10   0.925    -.2839311    .3124298
      dist_mps |   .0464755   .0264102     1.76   0.082     -.006035     .098986
  acrime_num_m |  -.0161825   .0088417    -1.83   0.071    -.0337623    .0013973
  psm2_z_wmiss |  -.0045395   .0817167    -0.06   0.956    -.1670143    .1579352
   ds2_z_wmiss |    .173654   .0723787     2.40   0.019     .0297457    .3175623
 grit2_z_wmiss |   .0036499   .1001493     0.04   0.971    -.1954737    .2027735
  bfi2_z_wmiss |  -.1201783   .1017777    -1.18   0.241    -.3225396     .082183
         _cons |   -1.44393    5.68826    -0.25   0.800    -12.75371    9.865854
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    85) =    1.56
            Prob > F =    0.2044

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
     overall |        248    2.080645    .9445927         -2          3
Table_A9.tex
Table_A9.xls
dir : seeout
F-test p-value for overall: .204, Dependent variable mean: 2.08

. 
. 
. ************
. * Table A4 *
. ************
. 
. foreach i in effort reliable responsive experience creative trustworthy approac
> h confident empathy overall {
  2. 
.     // Run the regression
.     reg `i' psm_z_wmiss ds_z_wmiss grit_z_wmiss ///
>     extroversion_z_wmiss agreeable_z_wmiss conscientious_z_wmiss neuroticism_z_
> wmiss openness_z_wmiss ///
>     $controls_bgy, vce(cl bgy)
  3.     
.     // Perform the F-test
.     test extroversion_z_wmiss = agreeable_z_wmiss = conscientious_z_wmiss = neu
> roticism_z_wmiss = openness_z_wmiss
  4.     
.     // Capture the p-value from the F-test and round it to 3 decimal points
.     local p_value = round(r(p), 0.001)
  5.     
.     // Calculate the mean of the dependent variable and round it to 2 decimal p
> oints
.     sum `i'
  6.     local depvar_mean = round(r(mean), 0.01)
  7.     
.     // Store the estimates for this regression
.     estimates store reg_`i'
  8. 
.     // Output the regression table, only keeping the specified variables, hidin
> g the constant, and using labels
.     if "`i'" == "effort" {
  9.         outreg2 [reg_`i'] using "Table_A4.xls", replace tex dec(3) ///
>         keep(extroversion_z_wmiss agreeable_z_wmiss conscientious_z_wmiss neuro
> ticism_z_wmiss openness_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 10.     }
 11.     else {
 12.         outreg2 [reg_`i'] using "Table_A4.xls", append tex dec(3) ///
>         keep(extroversion_z_wmiss agreeable_z_wmiss conscientious_z_wmiss neuro
> ticism_z_wmiss openness_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 13.     }
 14. 
.     // Optionally display the rounded p-value and dependent variable mean in th
> e console for confirmation
.     di "F-test p-value for `i': `p_value', Dependent variable mean: `depvar_mea
> n'"
 15. }

Linear regression                               Number of obs     =        255
                                                F(21, 92)         =       3.63
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1274
                                                Root MSE          =     .97726

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
        effort | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2906024    .070817     4.10   0.000     .1499537    .4312511
    ds_z_wmiss |  -.1855109   .0557965    -3.32   0.001    -.2963276   -.0746941
  grit_z_wmiss |   .1129252    .077832     1.45   0.150    -.0416559    .2675063
extroversion~s |   .0644224    .074096     0.87   0.387    -.0827386    .2115834
agreeable_z_~s |   -.272977    .095328    -2.86   0.005    -.4623067   -.0836473
conscientiou~s |   .0134599   .0958318     0.14   0.889    -.1768703      .20379
neuroticism_~s |   .1010069   .0945821     1.07   0.288    -.0868414    .2888552
openness_z_w~s |  -.0691868   .0911189    -0.76   0.450    -.2501568    .1117833
c10_population |   -.000021   .0001284    -0.16   0.870    -.0002759    .0002339
      c10_male |   2.245282   5.003452     0.45   0.655    -7.692005    12.18257
    c10_hhsize |  -.0699187   .2612244    -0.27   0.790    -.5887329    .4488956
       c10_ofw |  -7.574649   4.567865    -1.66   0.101    -16.64682    1.497525
 c10_education |   1.593153     .45655     3.49   0.001     .6864051      2.4999
  c10_age18_39 |  -.3758952   1.583181    -0.24   0.813     -3.52023     2.76844
 c10_ms_single |  -4.613841   3.031077    -1.52   0.131    -10.63382    1.406139
  c10_catholic |   .4890626   2.034191     0.24   0.811    -3.551017    4.529142
        c10_ip |   7.656727   7.686779     1.00   0.322     -7.60988    22.92333
 c10_home_good |  -2.994868   5.468615    -0.55   0.585    -13.85601    7.866274
      npa_2015 |   .0289675     .14944     0.19   0.847    -.2678333    .3257682
      dist_mps |  -.0076978    .023549    -0.33   0.744    -.0544682    .0390726
  acrime_num_m |  -.0075114   .0089397    -0.84   0.403    -.0252665    .0102437
         _cons |   .4182649    4.96376     0.08   0.933     -9.44019    10.27672
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    92) =    2.00
            Prob > F =    0.1015

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
      effort |        257    1.996109    .9980373         -2          3
Table_A4.tex
Table_A4.xls
dir : seeout
F-test p-value for effort: .102, Dependent variable mean: 2

Linear regression                               Number of obs     =        255
                                                F(21, 92)         =       1.70
                                                Prob > F          =     0.0454
                                                R-squared         =     0.0849
                                                Root MSE          =     .95971

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
      reliable | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2836915   .0766866     3.70   0.000     .1313853    .4359976
    ds_z_wmiss |  -.1227717   .0645843    -1.90   0.060    -.2510417    .0054983
  grit_z_wmiss |   .0043232   .0874311     0.05   0.961    -.1693224    .1779688
extroversion~s |   .0511804   .0768188     0.67   0.507    -.1013883    .2037491
agreeable_z_~s |  -.1893427    .100852    -1.88   0.064    -.3896434     .010958
conscientiou~s |    .009994   .1015777     0.10   0.922    -.1917481    .2117361
neuroticism_~s |   .0561761   .0982023     0.57   0.569    -.1388622    .2512143
openness_z_w~s |  -.0673257   .0871071    -0.77   0.442     -.240328    .1056765
c10_population |  -.0000879   .0001614    -0.54   0.587    -.0004085    .0002326
      c10_male |   .9653338   5.132145     0.19   0.851     -9.22755    11.15822
    c10_hhsize |  -.0769205   .2799807    -0.27   0.784    -.6329863    .4791453
       c10_ofw |  -8.099165   5.385375    -1.50   0.136    -18.79498    2.596653
 c10_education |   1.044246    .478726     2.18   0.032     .0934545    1.995037
  c10_age18_39 |  -.5737104   1.711489    -0.34   0.738    -3.972876    2.825455
 c10_ms_single |  -2.694302   3.212964    -0.84   0.404    -9.075526    3.686923
  c10_catholic |  -1.356535   1.800755    -0.75   0.453    -4.932989    2.219919
        c10_ip |   3.257162   8.879628     0.37   0.715    -14.37855    20.89287
 c10_home_good |  -.3361009   6.115263    -0.05   0.956    -12.48154    11.80934
      npa_2015 |   .0791495   .1484699     0.53   0.595    -.2157245    .3740235
      dist_mps |  -.0073264   .0263496    -0.28   0.782    -.0596589    .0450061
  acrime_num_m |  -.0096843   .0102838    -0.94   0.349    -.0301088    .0107403
         _cons |   2.561472   5.284562     0.48   0.629    -7.934124    13.05707
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    92) =    0.92
            Prob > F =    0.4563

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    reliable |        257    2.042802    .9571466         -2          3
Table_A4.tex
Table_A4.xls
dir : seeout
F-test p-value for reliable: .456, Dependent variable mean: 2.04

Linear regression                               Number of obs     =        254
                                                F(21, 92)         =       3.42
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1262
                                                Root MSE          =     1.0695

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
    responsive | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1936488   .0852159     2.27   0.025     .0244026    .3628949
    ds_z_wmiss |  -.2336122   .0613672    -3.81   0.000    -.3554928   -.1117316
  grit_z_wmiss |  -.1532744   .0904602    -1.69   0.094    -.3329362    .0263874
extroversion~s |   .2357133   .0954794     2.47   0.015      .046083    .4253436
agreeable_z_~s |  -.1510001   .0985599    -1.53   0.129    -.3467485    .0447484
conscientiou~s |  -.0410665   .1001164    -0.41   0.683    -.2399063    .1577733
neuroticism_~s |   .0922704   .0970673     0.95   0.344    -.1005136    .2850544
openness_z_w~s |  -.0796211   .0867196    -0.92   0.361    -.2518536    .0926115
c10_population |   5.90e-07   .0002041     0.00   0.998    -.0004047    .0004059
      c10_male |  -2.403698   6.402623    -0.38   0.708    -15.11986    10.31246
    c10_hhsize |  -.3162721   .2587664    -1.22   0.225    -.8302045    .1976603
       c10_ofw |   6.100511   7.800831     0.78   0.436    -9.392613    21.59364
 c10_education |   .6302548   .6137544     1.03   0.307    -.5887143    1.849224
  c10_age18_39 |    .682158   1.948738     0.35   0.727    -3.188204     4.55252
 c10_ms_single |  -5.743838   3.345389    -1.72   0.089    -12.38807    .9003937
  c10_catholic |   .1872824   2.326499     0.08   0.936    -4.433346    4.807911
        c10_ip |   6.534993   6.703481     0.97   0.332      -6.7787    19.84869
 c10_home_good |  -12.19211    5.87359    -2.08   0.041    -23.85757     -.52665
      npa_2015 |   .3035544   .1421297     2.14   0.035     .0212725    .5858363
      dist_mps |  -.0339966   .0308869    -1.10   0.274    -.0953406    .0273475
  acrime_num_m |  -.0033508    .009845    -0.34   0.734    -.0229038    .0162022
         _cons |   8.548822   5.811573     1.47   0.145    -2.993463    20.09111
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    92) =    2.78
            Prob > F =    0.0315

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  responsive |        256     1.84375     1.09141         -3          3
Table_A4.tex
Table_A4.xls
dir : seeout
F-test p-value for responsive: .031, Dependent variable mean: 1.84

Linear regression                               Number of obs     =        246
                                                F(21, 92)         =       2.97
                                                Prob > F          =     0.0002
                                                R-squared         =     0.1305
                                                Root MSE          =     1.1594

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
    experience | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .3085695   .0950714     3.25   0.002     .1197494    .4973896
    ds_z_wmiss |  -.1802868    .077057    -2.34   0.021    -.3333286   -.0272449
  grit_z_wmiss |  -.1556355   .1046836    -1.49   0.141    -.3635461    .0522751
extroversion~s |   .2111695   .1182002     1.79   0.077    -.0235863    .4459254
agreeable_z_~s |  -.1506505   .1183651    -1.27   0.206    -.3857339    .0844329
conscientiou~s |   .0104226   .1389454     0.08   0.940     -.265535    .2863802
neuroticism_~s |  -.0399034    .134345    -0.30   0.767    -.3067242    .2269174
openness_z_w~s |  -.0830492   .0964591    -0.86   0.391    -.2746253    .1085268
c10_population |   .0002977   .0002088     1.43   0.157     -.000117    .0007123
      c10_male |   4.642103    6.80025     0.68   0.497     -8.86378    18.14799
    c10_hhsize |  -.3097942   .3123823    -0.99   0.324    -.9302125    .3106241
       c10_ofw |   5.563237   7.167569     0.78   0.440    -8.672174    19.79865
 c10_education |   .7954787   .6999649     1.14   0.259     -.594712    2.185669
  c10_age18_39 |  -1.775449   1.935597    -0.92   0.361    -5.619713    2.068815
 c10_ms_single |   -7.40448   3.766676    -1.97   0.052    -14.88542    .0764631
  c10_catholic |   1.469614   2.583601     0.57   0.571     -3.66164    6.600869
        c10_ip |   5.184182   8.323563     0.62   0.535    -11.34713     21.7155
 c10_home_good |  -11.22374   6.749118    -1.66   0.100    -24.62807    2.180593
      npa_2015 |   .3005941   .2212366     1.36   0.178    -.1388008     .739989
      dist_mps |  -.0724046     .03155    -2.29   0.024    -.1350655   -.0097437
  acrime_num_m |   .0074252   .0136456     0.54   0.588    -.0196762    .0345265
         _cons |   4.626845   5.986821     0.77   0.442    -7.263498    16.51719
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    92) =    1.67
            Prob > F =    0.1640

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
  experience |        248    1.729839    1.185095         -3          3
Table_A4.tex
Table_A4.xls
dir : seeout
F-test p-value for experience: .164, Dependent variable mean: 1.73

Linear regression                               Number of obs     =        249
                                                F(21, 91)         =       1.44
                                                Prob > F          =     0.1193
                                                R-squared         =     0.1061
                                                Root MSE          =     1.1291

                                     (Std. err. adjusted for 92 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
      creative | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2720392   .1089249     2.50   0.014     .0556734    .4884051
    ds_z_wmiss |  -.1214427   .0665868    -1.82   0.071    -.2537091    .0108237
  grit_z_wmiss |  -.0173193   .1001127    -0.17   0.863    -.2161808    .1815422
extroversion~s |   .0572342   .1118746     0.51   0.610    -.1649909    .2794593
agreeable_z_~s |  -.1385992    .132725    -1.04   0.299    -.4022412    .1250428
conscientiou~s |   .0450135   .1317159     0.34   0.733    -.2166239    .3066509
neuroticism_~s |   .0460474   .1227271     0.38   0.708    -.1977349    .2898298
openness_z_w~s |  -.0344708   .1018863    -0.34   0.736    -.2368554    .1679137
c10_population |   .0001362   .0001902     0.72   0.476    -.0002416    .0005139
      c10_male |  -3.710036   6.444956    -0.58   0.566    -16.51215    9.092077
    c10_hhsize |  -.4056868   .3306405    -1.23   0.223    -1.062463    .2510899
       c10_ofw |   -5.15939   9.834833    -0.52   0.601    -24.69508     14.3763
 c10_education |   .1315854   .6673049     0.20   0.844    -1.193934    1.457105
  c10_age18_39 |  -2.011697   2.258773    -0.89   0.375    -6.498473    2.475078
 c10_ms_single |  -.9171299   3.628873    -0.25   0.801     -8.12544     6.29118
  c10_catholic |  -5.849625   2.144601    -2.73   0.008    -10.10961   -1.589638
        c10_ip |   .6646733   10.21124     0.07   0.948     -19.6187    20.94805
 c10_home_good |   -7.95806   7.286723    -1.09   0.278    -22.43224    6.516121
      npa_2015 |   .0244708   .1762988     0.14   0.890    -.3257251    .3746667
      dist_mps |    .008957   .0288882     0.31   0.757    -.0484259    .0663399
  acrime_num_m |  -.0028202   .0129125    -0.22   0.828    -.0284693     .022829
         _cons |   14.39549   6.466687     2.23   0.028     1.550213    27.24077
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    91) =    0.40
            Prob > F =    0.8075

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    creative |        251     1.63745    1.138434         -2          3
Table_A4.tex
Table_A4.xls
dir : seeout
F-test p-value for creative: .8080000000000001, Dependent variable mean: 1.64

Linear regression                               Number of obs     =        250
                                                F(21, 92)         =       1.33
                                                Prob > F          =     0.1779
                                                R-squared         =     0.1134
                                                Root MSE          =     .98502

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
   trustworthy | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2882114   .0808394     3.57   0.001     .1276573    .4487654
    ds_z_wmiss |  -.1670891   .0681612    -2.45   0.016    -.3024632    -.031715
  grit_z_wmiss |  -.1729528   .1024455    -1.69   0.095    -.3764183    .0305127
extroversion~s |   .1510395   .0863622     1.75   0.084    -.0204833    .3225623
agreeable_z_~s |    -.24359   .1167447    -2.09   0.040     -.475455    -.011725
conscientiou~s |   .0657742   .1504978     0.44   0.663    -.2331275    .3646758
neuroticism_~s |  -.0467872   .1100641    -0.43   0.672    -.2653841    .1718096
openness_z_w~s |  -.0099836   .0967683    -0.10   0.918    -.2021738    .1822066
c10_population |  -.0000705   .0001624    -0.43   0.665     -.000393    .0002519
      c10_male |   -6.09265    6.21039    -0.98   0.329    -18.42702    6.241719
    c10_hhsize |  -.1022645   .2949516    -0.35   0.730    -.6880637    .4835348
       c10_ofw |    .782393   5.942814     0.13   0.896    -11.02055    12.58533
 c10_education |   .7796892   .5927076     1.32   0.192    -.3974792    1.956858
  c10_age18_39 |   1.896105   1.847814     1.03   0.308    -1.773813    5.566023
 c10_ms_single |  -2.992622   3.407276    -0.88   0.382    -9.759765    3.774522
  c10_catholic |    1.55265   2.030242     0.76   0.446    -2.479585    5.584884
        c10_ip |   10.39799   7.759437     1.34   0.184     -5.01292     25.8089
 c10_home_good |  -.6624172   6.747413    -0.10   0.922    -14.06336    12.73853
      npa_2015 |   .2842249   .1854336     1.53   0.129    -.0840622     .652512
      dist_mps |   .0173864   .0303361     0.57   0.568    -.0428638    .0776366
  acrime_num_m |  -.0064258    .010862    -0.59   0.556    -.0279986    .0151471
         _cons |   2.526849    5.55952     0.45   0.651    -8.514837    13.56853
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    92) =    2.41
            Prob > F =    0.0545

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
 trustworthy |        252    2.146825    .9971423         -3          3
Table_A4.tex
Table_A4.xls
dir : seeout
F-test p-value for trustworthy: .055, Dependent variable mean: 2.15

Linear regression                               Number of obs     =        248
                                                F(21, 92)         =       1.95
                                                Prob > F          =     0.0160
                                                R-squared         =     0.0983
                                                Root MSE          =     .90955

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
      approach | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2166667   .0659816     3.28   0.001     .0856216    .3477118
    ds_z_wmiss |  -.1213283   .0675248    -1.80   0.076    -.2554384    .0127819
  grit_z_wmiss |  -.1487012   .0741091    -2.01   0.048    -.2958882   -.0015142
extroversion~s |    .192845   .0914841     2.11   0.038     .0111497    .3745403
agreeable_z_~s |  -.1527064   .0923739    -1.65   0.102     -.336169    .0307561
conscientiou~s |   .0677322   .0963125     0.70   0.484    -.1235527    .2590171
neuroticism_~s |  -.0762348   .0902212    -0.84   0.400     -.255422    .1029523
openness_z_w~s |  -.1117438   .0843227    -1.33   0.188     -.279216    .0557284
c10_population |  -.0000335   .0001733    -0.19   0.847    -.0003776    .0003107
      c10_male |   .6465637   4.636173     0.14   0.889    -8.561275    9.854403
    c10_hhsize |   .0233024   .2008454     0.12   0.908    -.3755939    .4221987
       c10_ofw |  -1.522852   4.387999    -0.35   0.729     -10.2378    7.192092
 c10_education |   1.012924   .4765018     2.13   0.036     .0665507    1.959298
  c10_age18_39 |   1.075089    1.61052     0.67   0.506    -2.123542    4.273721
 c10_ms_single |  -2.497983   3.039193    -0.82   0.413    -8.534083    3.538117
  c10_catholic |   1.051435   1.793357     0.59   0.559    -2.510327    4.613197
        c10_ip |   8.964691   6.297317     1.42   0.158    -3.542324    21.47171
 c10_home_good |   2.613568   5.812214     0.45   0.654    -8.929992    14.15713
      npa_2015 |   .2615138   .1438942     1.82   0.072    -.0242724    .5473001
      dist_mps |   .0037054   .0203822     0.18   0.856    -.0367754    .0441862
  acrime_num_m |  -.0094341   .0099605    -0.95   0.346    -.0292166    .0103484
         _cons |  -1.981163   4.695999    -0.42   0.674    -11.30782    7.345496
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    92) =    3.12
            Prob > F =    0.0187

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
    approach |        250        2.22    .9159453         -1          3
Table_A4.tex
Table_A4.xls
dir : seeout
F-test p-value for approach: .019, Dependent variable mean: 2.22

Linear regression                               Number of obs     =        248
                                                F(21, 92)         =       2.57
                                                Prob > F          =     0.0010
                                                R-squared         =     0.0980
                                                Root MSE          =      .9672

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
     confident | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2590983   .0675715     3.83   0.000     .1248955    .3933011
    ds_z_wmiss |  -.2334445   .0594135    -3.93   0.000    -.3514449   -.1154442
  grit_z_wmiss |  -.0519416   .0762753    -0.68   0.498    -.2034309    .0995477
extroversion~s |   .1566637   .0840298     1.86   0.065    -.0102267     .323554
agreeable_z_~s |  -.2150368   .0877103    -2.45   0.016    -.3892371   -.0408366
conscientiou~s |   .0275698   .0968042     0.28   0.776    -.1646916    .2198313
neuroticism_~s |  -.0523703   .0910175    -0.58   0.566     -.233139    .1283984
openness_z_w~s |  -.0222834   .0782616    -0.28   0.776    -.1777177    .1331509
c10_population |   .0000666   .0001352     0.49   0.624    -.0002019     .000335
      c10_male |   4.322026   3.995832     1.08   0.282    -3.614041    12.25809
    c10_hhsize |  -.0697211   .2692369    -0.26   0.796    -.6044489    .4650066
       c10_ofw |  -1.285503   5.560159    -0.23   0.818    -12.32846    9.757453
 c10_education |    .831756   .4757827     1.75   0.084    -.1131894    1.776702
  c10_age18_39 |  -1.300674    1.70527    -0.76   0.448    -4.687488    2.086139
 c10_ms_single |  -3.353934   2.504274    -1.34   0.184    -8.327638     1.61977
  c10_catholic |  -.8232157   1.924186    -0.43   0.670    -4.644815    2.998384
        c10_ip |   8.581542   5.795421     1.48   0.142    -2.928665    20.09175
 c10_home_good |  -3.535876   5.612911    -0.63   0.530     -14.6836    7.611851
      npa_2015 |   .1362053   .1551501     0.88   0.382    -.1719362    .4443468
      dist_mps |     .00671   .0268827     0.25   0.803    -.0466814    .0601014
  acrime_num_m |  -.0049036   .0098311    -0.50   0.619     -.024429    .0146218
         _cons |   2.225158   4.751243     0.47   0.641    -7.211222    11.66154
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    92) =    3.22
            Prob > F =    0.0161

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   confident |        250       2.072     .979107         -1          3
Table_A4.tex
Table_A4.xls
dir : seeout
F-test p-value for confident: .016, Dependent variable mean: 2.07

Linear regression                               Number of obs     =        240
                                                F(21, 91)         =       3.59
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1264
                                                Root MSE          =     1.0826

                                     (Std. err. adjusted for 92 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
       empathy | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2477977   .0739283     3.35   0.001     .1009483    .3946472
    ds_z_wmiss |  -.2235691   .0594803    -3.76   0.000    -.3417193   -.1054189
  grit_z_wmiss |   .0968741   .0790967     1.22   0.224    -.0602419    .2539901
extroversion~s |   .1730049   .0983837     1.76   0.082    -.0224221    .3684319
agreeable_z_~s |  -.1521195   .1045616    -1.45   0.149    -.3598184    .0555793
conscientiou~s |  -.0766979   .1152548    -0.67   0.507    -.3056373    .1522416
neuroticism_~s |  -.0069608   .1086375    -0.06   0.949    -.2227559    .2088344
openness_z_w~s |  -.1495629   .0972557    -1.54   0.128    -.3427494    .0436237
c10_population |   .0002955   .0001485     1.99   0.050     5.78e-07    .0005904
      c10_male |  -.7818482   5.057674    -0.15   0.877     -10.8283      9.2646
    c10_hhsize |  -.1027608   .2682416    -0.38   0.703    -.6355897    .4300681
       c10_ofw |  -7.551513   7.046579    -1.07   0.287    -21.54868    6.445651
 c10_education |   .3210118   .6321256     0.51   0.613    -.9346281    1.576652
  c10_age18_39 |  -.9067676   1.719597    -0.53   0.599    -4.322535       2.509
 c10_ms_single |  -.9286785   2.740747    -0.34   0.736    -6.372835    4.515479
  c10_catholic |  -2.173511   1.899257    -1.14   0.255    -5.946151     1.59913
        c10_ip |  -2.309504   6.302612    -0.37   0.715    -14.82887    10.20986
 c10_home_good |  -2.496227   5.920559    -0.42   0.674    -14.25669    9.264236
      npa_2015 |   .2116968   .1696044     1.25   0.215    -.1252015    .5485952
      dist_mps |  -.0317888    .026402    -1.20   0.232    -.0842331    .0206554
  acrime_num_m |   .0012853    .013317     0.10   0.923    -.0251672    .0277378
         _cons |   5.667842   5.336743     1.06   0.291    -4.932943    16.26863
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    91) =    1.72
            Prob > F =    0.1521

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
     empathy |        242    1.859504    1.103038         -3          3
Table_A4.tex
Table_A4.xls
dir : seeout
F-test p-value for empathy: .152, Dependent variable mean: 1.86

Linear regression                               Number of obs     =        246
                                                F(21, 91)         =       1.49
                                                Prob > F          =     0.1015
                                                R-squared         =     0.0851
                                                Root MSE          =     .94873

                                     (Std. err. adjusted for 92 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
       overall | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .2352251   .0757355     3.11   0.003      .084786    .3856643
    ds_z_wmiss |  -.1243399   .0586827    -2.12   0.037    -.2409059   -.0077738
  grit_z_wmiss |  -.0305228   .0727977    -0.42   0.676    -.1751266     .114081
extroversion~s |   .0032779    .093714     0.03   0.972    -.1828736    .1894293
agreeable_z_~s |  -.1967306   .0889373    -2.21   0.029    -.3733936   -.0200677
conscientiou~s |   .1447306   .1081583     1.34   0.184    -.0701126    .3595737
neuroticism_~s |   .0195773   .1052797     0.19   0.853    -.1895479    .2287026
openness_z_w~s |  -.0566209   .0876673    -0.65   0.520    -.2307612    .1175193
c10_population |  -.0000302   .0001869    -0.16   0.872    -.0004014     .000341
      c10_male |  -2.794441   5.401675    -0.52   0.606     -13.5242    7.935322
    c10_hhsize |  -.0124233   .3089395    -0.04   0.968    -.6260937    .6012471
       c10_ofw |  -.0087959   6.659201    -0.00   0.999    -13.23648    13.21889
 c10_education |   .7286552   .5357509     1.36   0.177    -.3355481    1.792859
  c10_age18_39 |   2.772971   2.036553     1.36   0.177    -1.272391    6.818333
 c10_ms_single |  -1.714342   2.698606    -0.64   0.527    -7.074791    3.646107
  c10_catholic |   .2507435   2.103181     0.12   0.905    -3.926967    4.428454
        c10_ip |   6.973479   6.864603     1.02   0.312    -6.662211    20.60917
 c10_home_good |   1.195057   5.863497     0.20   0.839    -10.45206    12.84217
      npa_2015 |   .0744297   .1521121     0.49   0.626    -.2277223    .3765817
      dist_mps |    .005365   .0311193     0.17   0.864    -.0564496    .0671795
  acrime_num_m |  -.0164378   .0105963    -1.55   0.124     -.037486    .0046104
         _cons |   .4829144   5.394187     0.09   0.929    -10.23197     11.1978
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    91) =    1.43
            Prob > F =    0.2305

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
     overall |        248    2.080645    .9445927         -2          3
Table_A4.tex
Table_A4.xls
dir : seeout
F-test p-value for overall: .231, Dependent variable mean: 2.08

. 
. 
. ************
. * Table A5 *
. ************
. 
. foreach i in responsive_act polcaseserious polcap_timely polint_corrupt_rc poli
> nt_quality satis_trust satis_general {
  2. 
.     // Run the regression
.     reg `i'_e psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss `i'_m ///
>     $controls_bgy, vce(cl bgy)
  3.     
.     // Perform the F-test
.     test psm_z_wmiss = ds_z_wmiss = grit_z_wmiss = bfi_z_wmiss
  4.     
.     // Capture the p-value from the F-test and round it to 3 decimal points
.     local p_value = round(r(p), 0.001)
  5.     
.     // Calculate the mean of the dependent variable and round it to 2 decimal p
> oints
.     sum `i'_e
  6.     local depvar_mean = round(r(mean), 0.01)
  7.     
.     // Store the estimates for this regression
.     estimates store reg_`i'
  8. 
.     // Output the regression table, only keeping the specified variables, hidin
> g the constant, and using labels
.     if "`i'" == "responsive_act" {
  9.         outreg2 [reg_`i'] using "Table_A5.xls", replace tex dec(3) ///
>         keep(psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 10.     }
 11.     else {
 12.         outreg2 [reg_`i'] using "Table_A5.xls", append tex dec(3) ///
>         keep(psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 13.     }
 14. 
.     // Optionally display the rounded p-value and dependent variable mean in th
> e console for confirmation
.     di "F-test p-value for `i': `p_value', Dependent variable mean: `depvar_mea
> n'"
 15. }

Linear regression                               Number of obs     =        235
                                                F(18, 93)         =       2.21
                                                Prob > F          =     0.0073
                                                R-squared         =     0.1226
                                                Root MSE          =     .71474

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
responsive_a~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.0347729    .066323    -0.52   0.601    -.1664771    .0969314
    ds_z_wmiss |  -.0335472   .0609627    -0.55   0.583     -.154607    .0875126
  grit_z_wmiss |   .1876233   .0684233     2.74   0.007     .0517482    .3234984
   bfi_z_wmiss |  -.0031462   .0705791    -0.04   0.965    -.1433024      .13701
responsive_a~m |   .0737253   .0721787     1.02   0.310    -.0696073     .217058
c10_population |   -.000072   .0001121    -0.64   0.523    -.0002946    .0001507
      c10_male |   1.001423   3.670156     0.27   0.786    -6.286778    8.289625
    c10_hhsize |  -.2009855   .1752451    -1.15   0.254    -.5489874    .1470165
       c10_ofw |   6.595246    4.12132     1.60   0.113    -1.588878    14.77937
 c10_education |    .189393   .3530328     0.54   0.593    -.5116603    .8904463
  c10_age18_39 |   3.122232   1.346627     2.32   0.023     .4480973    5.796366
 c10_ms_single |  -.2054779   2.132639    -0.10   0.923    -4.440477    4.029521
  c10_catholic |  -.6058491   1.360953    -0.45   0.657    -3.308432    2.096734
        c10_ip |  -5.675023   4.639007    -1.22   0.224    -14.88717    3.537127
 c10_home_good |  -.2682458   4.082796    -0.07   0.948     -8.37587    7.839378
      npa_2015 |  -.0523174   .1212017    -0.43   0.667    -.2929999    .1883652
      dist_mps |  -.0534857   .0172203    -3.11   0.003    -.0876817   -.0192896
  acrime_num_m |   .0040778   .0053545     0.76   0.448    -.0065552    .0147107
         _cons |   .3882549   3.586553     0.11   0.914    -6.733928    7.510437
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    3.20
            Prob > F =    0.0270

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
responsive~e |        283    1.388693    .7467277         -1          2
Table_A5.tex
Table_A5.xls
dir : seeout
F-test p-value for responsive_act: .027, Dependent variable mean: 1.39

Linear regression                               Number of obs     =        236
                                                F(18, 93)         =       1.34
                                                Prob > F          =     0.1799
                                                R-squared         =     0.0837
                                                Root MSE          =     .66519

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polcaseserio~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0099697   .0698452     0.14   0.887    -.1287289    .1486684
    ds_z_wmiss |  -.0478412   .0556161    -0.86   0.392    -.1582838    .0626014
  grit_z_wmiss |   .0677382   .0618225     1.10   0.276    -.0550291    .1905055
   bfi_z_wmiss |   .0139783   .0722072     0.19   0.847    -.1294108    .1573674
polcaseserio~m |   .1193497   .0610608     1.95   0.054     -.001905    .2406044
c10_population |  -.0000699   .0000962    -0.73   0.469    -.0002609    .0001211
      c10_male |    3.43488   3.559762     0.96   0.337    -3.634102    10.50386
    c10_hhsize |   .0189532   .1549586     0.12   0.903    -.2887639    .3266702
       c10_ofw |   5.635067   3.500775     1.61   0.111    -1.316778    12.58691
 c10_education |   .0557091   .3334007     0.17   0.868    -.6063587    .7177768
  c10_age18_39 |   1.775489    1.10356     1.61   0.111    -.4159622     3.96694
 c10_ms_single |  -.6730292   1.922969    -0.35   0.727    -4.491665    3.145606
  c10_catholic |    .416953    1.16161     0.36   0.720    -1.889775    2.723681
        c10_ip |  -2.098069   3.873075    -0.54   0.589    -9.789228     5.59309
 c10_home_good |   .3404423   3.787378     0.09   0.929     -7.18054    7.861425
      npa_2015 |  -.1043452   .1108193    -0.94   0.349    -.3244105      .11572
      dist_mps |  -.0465468   .0160706    -2.90   0.005    -.0784599   -.0146338
  acrime_num_m |   .0012143   .0042369     0.29   0.775    -.0071994    .0096279
         _cons |   -1.63499   3.483175    -0.47   0.640    -8.551886    5.281906
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    1.09
            Prob > F =    0.3585

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polcaseser~e |        283    1.491166    .6756345         -1          2
Table_A5.tex
Table_A5.xls
dir : seeout
F-test p-value for polcaseserious: .358, Dependent variable mean: 1.49

Linear regression                               Number of obs     =        231
                                                F(18, 92)         =       2.01
                                                Prob > F          =     0.0163
                                                R-squared         =     0.1392
                                                Root MSE          =     .78228

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polcap_timel~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.0496619   .1005361    -0.49   0.623    -.2493353    .1500114
    ds_z_wmiss |   .0135506   .0735647     0.18   0.854    -.1325552    .1596564
  grit_z_wmiss |   .1078563    .074372     1.45   0.150    -.0398529    .2555656
   bfi_z_wmiss |  -.0431879    .086041    -0.50   0.617    -.2140728     .127697
polcap_timel~m |   .2290319   .0632999     3.62   0.000     .1033129    .3547509
c10_population |   .0001056   .0001367     0.77   0.442    -.0001659    .0003771
      c10_male |  -.7717212   5.007572    -0.15   0.878    -10.71719    9.173749
    c10_hhsize |  -.0619478    .212091    -0.29   0.771    -.4831787    .3592832
       c10_ofw |   5.426652   4.771632     1.14   0.258     -4.05022    14.90352
 c10_education |  -.6941923   .5319741    -1.30   0.195    -1.750739    .3623542
  c10_age18_39 |   1.297943   1.571014     0.83   0.411    -1.822227    4.418112
 c10_ms_single |  -1.586445    2.87798    -0.55   0.583    -7.302362    4.129472
  c10_catholic |   .3182339   1.866178     0.17   0.865    -3.388157    4.024625
        c10_ip |  -1.654789   7.221197    -0.23   0.819    -15.99671    12.68713
 c10_home_good |  -7.117248    5.10522    -1.39   0.167    -17.25666    3.022159
      npa_2015 |   -.014259   .1564458    -0.09   0.928    -.3249738    .2964558
      dist_mps |  -.0590872   .0258649    -2.28   0.025    -.1104572   -.0077173
  acrime_num_m |   .0097511   .0064688     1.51   0.135    -.0030965    .0225988
         _cons |   5.094193   4.700829     1.08   0.281    -4.242059    14.43045
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    92) =    0.70
            Prob > F =    0.5524

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polcap_tim~e |        280    1.271429    .8195012         -2          2
Table_A5.tex
Table_A5.xls
dir : seeout
F-test p-value for polcap_timely: .552, Dependent variable mean: 1.27

Linear regression                               Number of obs     =        211
                                                F(18, 89)         =       1.87
                                                Prob > F          =     0.0289
                                                R-squared         =     0.1168
                                                Root MSE          =     .90534

                                     (Std. err. adjusted for 90 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polint_corru~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0839651   .0899266     0.93   0.353    -.0947172    .2626474
    ds_z_wmiss |  -.1425875   .0863247    -1.65   0.102    -.3141128    .0289378
  grit_z_wmiss |  -.0690278   .0812395    -0.85   0.398    -.2304489    .0923933
   bfi_z_wmiss |  -.0359448    .079136    -0.45   0.651    -.1931863    .1212968
polint_corru~m |   .1817859   .0680883     2.67   0.009     .0464959    .3170758
c10_population |  -.0000305   .0001408    -0.22   0.829    -.0003103    .0002493
      c10_male |   8.680057    5.18265     1.67   0.097    -1.617758    18.97787
    c10_hhsize |   .0424764   .2949054     0.14   0.886    -.5434943    .6284471
       c10_ofw |  -4.948414    4.52578    -1.09   0.277    -13.94104    4.044215
 c10_education |   .5746308   .5419764     1.06   0.292    -.5022648    1.651526
  c10_age18_39 |  -4.226954   1.855626    -2.28   0.025    -7.914043   -.5398657
 c10_ms_single |  -7.580486   3.322922    -2.28   0.025    -14.18306    -.977911
  c10_catholic |   1.897201   2.416119     0.79   0.434    -2.903577    6.697978
        c10_ip |  -.4909639   6.594126    -0.07   0.941    -13.59335    12.61142
 c10_home_good |  -11.98196   7.486562    -1.60   0.113     -26.8576    2.893685
      npa_2015 |   .0322626   .1720355     0.19   0.852    -.3095683    .3740934
      dist_mps |  -.0337923   .0305683    -1.11   0.272    -.0945308    .0269463
  acrime_num_m |   .0019715   .0089676     0.22   0.826    -.0158469      .01979
         _cons |   4.498743    5.64737     0.80   0.428    -6.722461    15.71995
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    89) =    1.18
            Prob > F =    0.3234

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polint_cor~e |        272    3.231618    .9260639          0          4
Table_A5.tex
Table_A5.xls
dir : seeout
F-test p-value for polint_corrupt_rc: .323, Dependent variable mean: 3.23

Linear regression                               Number of obs     =        234
                                                F(18, 93)         =       2.65
                                                Prob > F          =     0.0012
                                                R-squared         =     0.1777
                                                Root MSE          =     .74493

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polint_quali~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.1370039   .0797555    -1.72   0.089    -.2953826    .0213748
    ds_z_wmiss |  -.0399548   .0585334    -0.68   0.497    -.1561904    .0762809
  grit_z_wmiss |    .149984    .064867     2.31   0.023      .021171     .278797
   bfi_z_wmiss |  -.0557538    .072964    -0.76   0.447    -.2006457    .0891382
polint_quali~m |   .2350447   .0649714     3.62   0.000     .1060244     .364065
c10_population |   -.000037   .0001397    -0.26   0.792    -.0003144    .0002404
      c10_male |  -7.953995   4.410849    -1.80   0.075    -16.71307    .8050772
    c10_hhsize |  -.1374768   .2093867    -0.66   0.513    -.5532773    .2783236
       c10_ofw |   5.536809   5.624966     0.98   0.328    -5.633258    16.70688
 c10_education |   -.457979    .468002    -0.98   0.330    -1.387338    .4713802
  c10_age18_39 |   3.186413   1.760439     1.81   0.074    -.3094695    6.682296
 c10_ms_single |  -1.264846   2.616376    -0.48   0.630    -6.460451    3.930759
  c10_catholic |   3.269391   2.222666     1.47   0.145    -1.144384    7.683165
        c10_ip |   2.245169   4.975938     0.45   0.653    -7.636058     12.1264
 c10_home_good |   -7.39653   4.717769    -1.57   0.120    -16.76508    1.972023
      npa_2015 |  -.0265509    .123045    -0.22   0.830    -.2708939     .217792
      dist_mps |  -.0461866   .0205632    -2.25   0.027    -.0870211   -.0053522
  acrime_num_m |   .0023872   .0062407     0.38   0.703    -.0100055      .01478
         _cons |    4.73663   4.884542     0.97   0.335    -4.963103    14.43636
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    2.99
            Prob > F =    0.0351

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polint_qua~e |        282    1.283688    .7943416         -2          2
Table_A5.tex
Table_A5.xls
dir : seeout
F-test p-value for polint_quality: .035, Dependent variable mean: 1.28

Linear regression                               Number of obs     =        236
                                                F(18, 93)         =       0.91
                                                Prob > F          =     0.5684
                                                R-squared         =     0.0610
                                                Root MSE          =     .61319

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
 satis_trust_e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.0659749    .049635    -1.33   0.187    -.1645401    .0325904
    ds_z_wmiss |   .0798414   .0473558     1.69   0.095    -.0141979    .1738806
  grit_z_wmiss |   .0608174   .0481341     1.26   0.210    -.0347673    .1564021
   bfi_z_wmiss |   -.013576   .0517345    -0.26   0.794    -.1163105    .0891585
 satis_trust_m |   .0739308   .0651899     1.13   0.260    -.0555235    .2033851
c10_population |   .0000246   .0001209     0.20   0.839    -.0002156    .0002648
      c10_male |   -1.87708   3.931723    -0.48   0.634    -9.684703    5.930542
    c10_hhsize |   -.051748   .1469279    -0.35   0.725    -.3435177    .2400217
       c10_ofw |   .4156685     3.8478     0.11   0.914    -7.225299    8.056636
 c10_education |  -.3063225   .3997149    -0.77   0.445    -1.100077    .4874321
  c10_age18_39 |   1.514545   1.058392     1.43   0.156    -.5872129    3.616302
 c10_ms_single |  -1.144986   1.835511    -0.62   0.534    -4.789948    2.499975
  c10_catholic |   .9926571   1.196696     0.83   0.409    -1.383744    3.369058
        c10_ip |    1.08845   3.422956     0.32   0.751    -5.708863    7.885763
 c10_home_good |   -2.51682   3.442613    -0.73   0.467    -9.353167    4.319526
      npa_2015 |  -.0657697   .1180749    -0.56   0.579     -.300243    .1687036
      dist_mps |  -.0200193   .0139155    -1.44   0.154    -.0476528    .0076142
  acrime_num_m |  -.0001323   .0038698    -0.03   0.973    -.0078169    .0075523
         _cons |   2.681877   3.351871     0.80   0.426    -3.974273    9.338028
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    1.52
            Prob > F =    0.2140

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
satis_trus~e |        283    1.515901     .609262          0          2
Table_A5.tex
Table_A5.xls
dir : seeout
F-test p-value for satis_trust: .214, Dependent variable mean: 1.52

Linear regression                               Number of obs     =        235
                                                F(18, 93)         =       1.64
                                                Prob > F          =     0.0664
                                                R-squared         =     0.1130
                                                Root MSE          =     .70424

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
satis_genera~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0430855   .0686027     0.63   0.532    -.0931459     .179317
    ds_z_wmiss |  -.0473155   .0646894    -0.73   0.466    -.1757759    .0811449
  grit_z_wmiss |   .0633467   .0568706     1.11   0.268    -.0495871    .1762805
   bfi_z_wmiss |  -.0403627   .0693611    -0.58   0.562    -.1781002    .0973747
satis_genera~m |   .1169405   .0497705     2.35   0.021     .0181061    .2157749
c10_population |    .000078   .0001159     0.67   0.503    -.0001522    .0003081
      c10_male |   1.372171   4.054997     0.34   0.736     -6.68025    9.424592
    c10_hhsize |  -.3641098    .185511    -1.96   0.053    -.7324979    .0042783
       c10_ofw |    .535024   5.995365     0.09   0.929    -11.37058    12.44063
 c10_education |  -.5316011   .3923238    -1.36   0.179    -1.310678    .2474763
  c10_age18_39 |   .4813136   1.408369     0.34   0.733    -2.315428    3.278056
 c10_ms_single |  -1.129097   2.030471    -0.56   0.579     -5.16121    2.903016
  c10_catholic |   1.040883   1.273686     0.82   0.416    -1.488405    3.570171
        c10_ip |  -.0746494   4.211061    -0.02   0.986    -8.436982    8.287683
 c10_home_good |  -5.433812   4.269465    -1.27   0.206    -13.91212      3.0445
      npa_2015 |   .0647519   .1216296     0.53   0.596    -.1767803    .3062841
      dist_mps |  -.0608833   .0188798    -3.22   0.002    -.0983748   -.0233918
  acrime_num_m |     .00637   .0046659     1.37   0.175    -.0028955    .0156355
         _cons |   3.947801   3.928129     1.01   0.318    -3.852686    11.74829
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    0.53
            Prob > F =    0.6617

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
satis_gene~e |        284    1.330986    .7492925         -1          2
Table_A5.tex
Table_A5.xls
dir : seeout
F-test p-value for satis_general: .662, Dependent variable mean: 1.33

. 
. 
. ************
. * Table A10 *
. ************
. 
. foreach i in responsive_act polcaseserious polcap_timely polint_corrupt_rc poli
> nt_quality satis_trust satis_general {
  2. 
.     // Run the regression
.     reg `i'_e psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss `i'_m, vce(cl bgy
> )
  3.     
.     // Perform the F-test
.     test psm_z_wmiss = ds_z_wmiss = grit_z_wmiss = bfi_z_wmiss
  4.     
.     // Capture the p-value from the F-test and round it to 3 decimal points
.     local p_value = round(r(p), 0.001)
  5.     
.     // Calculate the mean of the dependent variable and round it to 2 decimal p
> oints
.     sum `i'_e
  6.     local depvar_mean = round(r(mean), 0.01)
  7.     
.     // Store the estimates for this regression
.     estimates store reg_`i'
  8. 
.     // Output the regression table, only keeping the specified variables, hidin
> g the constant, and using labels
.     if "`i'" == "responsive_act" {
  9.         outreg2 [reg_`i'] using "Table_A10.xls", replace tex dec(3) ///
>         keep(psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 10.     }
 11.     else {
 12.         outreg2 [reg_`i'] using "Table_A10.xls", append tex dec(3) ///
>         keep(psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 13.     }
 14. 
.     // Optionally display the rounded p-value and dependent variable mean in th
> e console for confirmation
.     di "F-test p-value for `i': `p_value', Dependent variable mean: `depvar_mea
> n'"
 15. }

Linear regression                               Number of obs     =        236
                                                F(5, 94)          =       1.71
                                                Prob > F          =     0.1390
                                                R-squared         =     0.0390
                                                Root MSE          =     .72533

                                     (Std. err. adjusted for 95 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
responsive_a~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.0353282   .0589135    -0.60   0.550    -.1523023     .081646
    ds_z_wmiss |   .0129538   .0717413     0.18   0.857    -.1294901    .1553978
  grit_z_wmiss |   .1584408   .0642969     2.46   0.016     .0307778    .2861038
   bfi_z_wmiss |  -.0081914    .066009    -0.12   0.902    -.1392537    .1228709
responsive_a~m |   .0711906   .0717847     0.99   0.324    -.0713395    .2137207
         _cons |   1.290361   .1087783    11.86   0.000     1.074379    1.506343
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    94) =    1.61
            Prob > F =    0.1921

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
responsive~e |        283    1.388693    .7467277         -1          2
Table_A10.tex
Table_A10.xls
dir : seeout
F-test p-value for responsive_act: .192, Dependent variable mean: 1.39

Linear regression                               Number of obs     =        237
                                                F(5, 94)          =       1.43
                                                Prob > F          =     0.2204
                                                R-squared         =     0.0256
                                                Root MSE          =     .66574

                                     (Std. err. adjusted for 95 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polcaseserio~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0130573   .0596801     0.22   0.827    -.1054389    .1315536
    ds_z_wmiss |  -.0265358   .0621601    -0.43   0.670    -.1499561    .0968845
  grit_z_wmiss |   .0578575   .0546008     1.06   0.292    -.0505536    .1662686
   bfi_z_wmiss |    .006215   .0670243     0.09   0.926    -.1268633    .1392933
polcaseserio~m |   .1157201   .0597297     1.94   0.056    -.0028746    .2343147
         _cons |   1.312513   .1011462    12.98   0.000     1.111685    1.513341
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    94) =    0.49
            Prob > F =    0.6897

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polcaseser~e |        283    1.491166    .6756345         -1          2
Table_A10.tex
Table_A10.xls
dir : seeout
F-test p-value for polcaseserious: .6900000000000001, Dependent variable mean: 1.
> 49

Linear regression                               Number of obs     =        232
                                                F(5, 93)          =       3.55
                                                Prob > F          =     0.0056
                                                R-squared         =     0.0745
                                                Root MSE          =     .78984

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polcap_timel~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   -.048732   .0880294    -0.55   0.581    -.2235411     .126077
    ds_z_wmiss |   .0058492    .075938     0.08   0.939    -.1449486    .1566469
  grit_z_wmiss |   .0541946   .0698448     0.78   0.440    -.0845033    .1928925
   bfi_z_wmiss |  -.0050228   .0800332    -0.06   0.950    -.1639529    .1539072
polcap_timel~m |   .2275699   .0583656     3.90   0.000     .1116673    .3434724
         _cons |    1.01164   .0934959    10.82   0.000     .8259756    1.197304
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    93) =    0.24
            Prob > F =    0.8716

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polcap_tim~e |        280    1.271429    .8195012         -2          2
Table_A10.tex
Table_A10.xls
dir : seeout
F-test p-value for polcap_timely: .872, Dependent variable mean: 1.27

Linear regression                               Number of obs     =        212
                                                F(5, 90)          =       1.38
                                                Prob > F          =     0.2389
                                                R-squared         =     0.0422
                                                Root MSE          =     .91161

                                     (Std. err. adjusted for 91 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polint_corru~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0620687   .0861415     0.72   0.473    -.1090664    .2332038
    ds_z_wmiss |  -.1099856   .1030479    -1.07   0.289    -.3147084    .0947371
  grit_z_wmiss |  -.0290856   .0738349    -0.39   0.695    -.1757715    .1176003
   bfi_z_wmiss |  -.0728853   .0798515    -0.91   0.364    -.2315243    .0857536
polint_corru~m |   .1559828   .0671903     2.32   0.023     .0224976    .2894679
         _cons |    2.77907   .2365999    11.75   0.000     2.309023    3.249117
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    90) =    0.46
            Prob > F =    0.7131

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polint_cor~e |        272    3.231618    .9260639          0          4
Table_A10.tex
Table_A10.xls
dir : seeout
F-test p-value for polint_corrupt_rc: .713, Dependent variable mean: 3.23

Linear regression                               Number of obs     =        235
                                                F(5, 94)          =       3.43
                                                Prob > F          =     0.0068
                                                R-squared         =     0.0961
                                                Root MSE          =     .75696

                                     (Std. err. adjusted for 95 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polint_quali~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.1353671    .078329    -1.73   0.087    -.2908911    .0201569
    ds_z_wmiss |  -.0452016   .0657652    -0.69   0.494      -.17578    .0853768
  grit_z_wmiss |    .115237   .0689272     1.67   0.098    -.0216197    .2520936
   bfi_z_wmiss |  -.0074679   .0673539    -0.11   0.912    -.1412008    .1262649
polint_quali~m |   .2117111   .0648988     3.26   0.002      .082853    .3405692
         _cons |   1.007234   .1022486     9.85   0.000     .8042172    1.210251
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    94) =    1.58
            Prob > F =    0.2002

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polint_qua~e |        282    1.283688    .7943416         -2          2
Table_A10.tex
Table_A10.xls
dir : seeout
F-test p-value for polint_quality: .2, Dependent variable mean: 1.28

Linear regression                               Number of obs     =        237
                                                F(5, 94)          =       1.40
                                                Prob > F          =     0.2307
                                                R-squared         =     0.0281
                                                Root MSE          =     .60558

                                    (Std. err. adjusted for 95 clusters in bgy)
-------------------------------------------------------------------------------
              |               Robust
satis_trust_e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
  psm_z_wmiss |  -.0651339    .049539    -1.31   0.192    -.1634948    .0332269
   ds_z_wmiss |   .0587284   .0372932     1.57   0.119     -.015318    .1327749
 grit_z_wmiss |   .0466353   .0465189     1.00   0.319     -.045729    .1389995
  bfi_z_wmiss |   .0041506   .0512482     0.08   0.936    -.0976039    .1059052
satis_trust_m |   .0875658   .0594645     1.47   0.144    -.0305024     .205634
        _cons |   1.390669   .1025728    13.56   0.000     1.187008     1.59433
-------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    94) =    1.31
            Prob > F =    0.2748

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
satis_trus~e |        283    1.515901     .609262          0          2
Table_A10.tex
Table_A10.xls
dir : seeout
F-test p-value for satis_trust: .275, Dependent variable mean: 1.52

Linear regression                               Number of obs     =        236
                                                F(5, 94)          =       1.57
                                                Prob > F          =     0.1751
                                                R-squared         =     0.0328
                                                Root MSE          =     .71299

                                     (Std. err. adjusted for 95 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
satis_genera~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0555052   .0640466     0.87   0.388    -.0716608    .1826712
    ds_z_wmiss |  -.0408769    .065837    -0.62   0.536    -.1715979     .089844
  grit_z_wmiss |    .065553    .053255     1.23   0.221     -.040186    .1712921
   bfi_z_wmiss |  -.0452575   .0652489    -0.69   0.490    -.1748107    .0842957
satis_genera~m |   .1079475   .0487726     2.21   0.029     .0111083    .2047867
         _cons |   1.207996   .0773926    15.61   0.000     1.054331    1.361661
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    94) =    0.52
            Prob > F =    0.6681

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
satis_gene~e |        284    1.330986    .7492925         -1          2
Table_A10.tex
Table_A10.xls
dir : seeout
F-test p-value for satis_general: .668, Dependent variable mean: 1.33

. 
. 
. ************
. * Table A11 *
. ************
. 
. foreach i in responsive_act polcaseserious polcap_timely polint_corrupt_rc poli
> nt_quality satis_trust satis_general {
  2. 
.     // Run the regression
.     reg `i'_e psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss `i'_m ///
>     $controls_officer $controls_bgy_respondents $controls_bgy  $controls_junior
> , vce(cl bgy)
  3.     
.     // Perform the F-test
.     test psm_z_wmiss = ds_z_wmiss = grit_z_wmiss = bfi_z_wmiss
  4.     
.     // Capture the p-value from the F-test and round it to 3 decimal points
.     local p_value = round(r(p), 0.001)
  5.     
.     // Calculate the mean of the dependent variable and round it to 2 decimal p
> oints
.     sum `i'_e
  6.     local depvar_mean = round(r(mean), 0.01)
  7.     
.     // Store the estimates for this regression
.     estimates store reg_`i'
  8. 
.     // Output the regression table, only keeping the specified variables, hidin
> g the constant, and using labels
.     if "`i'" == "responsive_act" {
  9.         outreg2 [reg_`i'] using "Table_A11.xls", replace tex dec(3) ///
>                 drop(`i'_m) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 10.     }
 11.     else {
 12.         outreg2 [reg_`i'] using "Table_A11.xls", append tex dec(3) ///
>         drop(`i'_m) ///
>                 addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean
> ') label
 13.     }
 14. 
.     // Optionally display the rounded p-value and dependent variable mean in th
> e console for confirmation
.     di "F-test p-value for `i': `p_value', Dependent variable mean: `depvar_mea
> n'"
 15. }

Linear regression                               Number of obs     =        214
                                                F(38, 87)         =       2.10
                                                Prob > F          =     0.0024
                                                R-squared         =     0.2138
                                                Root MSE          =      .7093

                                     (Std. err. adjusted for 88 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
responsive_a~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.0598148   .0623719    -0.96   0.340    -.1837857    .0641562
    ds_z_wmiss |  -.0214712   .0595137    -0.36   0.719    -.1397611    .0968187
  grit_z_wmiss |   .1912147   .0626202     3.05   0.003     .0667502    .3156791
   bfi_z_wmiss |   .0519204   .0631027     0.82   0.413     -.073503    .1773438
responsive_a~m |   .0785641   .0781591     1.01   0.318    -.0767855    .2339138
        female |  -.0997873   .1803839    -0.55   0.582    -.4583199    .2587452
           age |   .0041889   .0134646     0.31   0.756    -.0225736    .0309513
  years_served |   -.017655   .0120022    -1.47   0.145    -.0415107    .0062007
        rank_m |    -.01788   .0731891    -0.24   0.808    -.1633512    .1275912
         educ1 |   .3221658   .2443848     1.32   0.191    -.1635755    .8079071
         educ2 |          0  (omitted)
         educ3 |  -.0784685   .1226844    -0.64   0.524     -.322317      .16538
       captain |    .043489   .1720461     0.25   0.801    -.2984711    .3854492
       kagawad |   .0991518   .1310734     0.76   0.451    -.1613707    .3596744
    chieftanod |          0  (omitted)
         age_e |   .0138064   .0077792     1.77   0.079    -.0016555    .0292684
   education_e |   .0296155   .0634931     0.47   0.642    -.0965839    .1558148
    employed_e |  -.0538373   .0361653    -1.49   0.140    -.1257197    .0180452
      income_e |  -6.98e-06   4.62e-06    -1.51   0.134    -.0000162    2.19e-06
reside_years_e |  -.0040403   .0040348    -1.00   0.319    -.0120599    .0039793
        male_e |   .0890842   .2127017     0.42   0.676    -.3336834    .5118518
 assets_roof_e |  -.0010279   .0058049    -0.18   0.860    -.0125658      .01051
years_served_e |  -.0033524   .0117717    -0.28   0.776      -.02675    .0200452
c10_population |   .0001094   .0001479     0.74   0.461    -.0001846    .0004034
      c10_male |    6.37392   3.947063     1.61   0.110    -1.471296    14.21914
    c10_hhsize |   .0063957   .1843103     0.03   0.972    -.3599409    .3727323
       c10_ofw |   8.797861   4.653952     1.89   0.062    -.4523735     18.0481
 c10_education |   .1910207   .3486497     0.55   0.585    -.5019583    .8839997
  c10_age18_39 |   1.080228   1.415404     0.76   0.447    -1.733041    3.893496
 c10_ms_single |   .0875294   2.327928     0.04   0.970     -4.53948    4.714539
  c10_catholic |   1.059194   1.648511     0.64   0.522    -2.217401    4.335788
        c10_ip |  -2.333598   5.728684    -0.41   0.685    -13.71998    9.052782
 c10_home_good |   .6650411   4.875329     0.14   0.892    -9.025202    10.35528
      npa_2015 |  -.0537162   .1112393    -0.48   0.630    -.2748164    .1673839
      dist_mps |  -.0425933   .0199578    -2.13   0.036    -.0822616    -.002925
  acrime_num_m |   .0069256   .0055894     1.24   0.219     -.004184    .0180352
  psm2_z_wmiss |   .1135022   .0672847     1.69   0.095    -.0202334    .2472378
   ds2_z_wmiss |  -.0053671   .0650698    -0.08   0.934    -.1347004    .1239661
 grit2_z_wmiss |   .1772289   .0589376     3.01   0.003      .060084    .2943739
  bfi2_z_wmiss |  -.1926044    .066366    -2.90   0.005    -.3245141   -.0606948
         _cons |  -4.237253   4.152141    -1.02   0.310    -12.49008    4.015576
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    87) =    3.88
            Prob > F =    0.0118

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
responsive~e |        283    1.388693    .7467277         -1          2
Table_A11.tex
Table_A11.xls
dir : seeout
F-test p-value for responsive_act: .012, Dependent variable mean: 1.39

Linear regression                               Number of obs     =        215
                                                F(38, 87)         =       7.19
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1939
                                                Root MSE          =     .66202

                                     (Std. err. adjusted for 88 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polcaseserio~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |    .014536   .0669621     0.22   0.829    -.1185584    .1476303
    ds_z_wmiss |  -.0544163   .0585797    -0.93   0.355    -.1708498    .0620172
  grit_z_wmiss |   .0455174   .0573768     0.79   0.430    -.0685252      .15956
   bfi_z_wmiss |   .0485639   .0639996     0.76   0.450    -.0786421      .17577
polcaseserio~m |   .1519061   .0676853     2.24   0.027     .0173743    .2864379
        female |   .1030273   .1406851     0.73   0.466    -.1765996    .3826541
           age |   .0092143   .0109036     0.85   0.400    -.0124578    .0308863
  years_served |  -.0307295   .0109765    -2.80   0.006    -.0525464   -.0089126
        rank_m |   .0211565   .0623157     0.34   0.735    -.1027027    .1450157
         educ1 |    .675457   .1645442     4.11   0.000     .3484075    1.002506
         educ2 |          0  (omitted)
         educ3 |   .1936403   .1107114     1.75   0.084    -.0264107    .4136913
       captain |  -.0744421    .154905    -0.48   0.632    -.3823327    .2334484
       kagawad |    .056112   .1156311     0.49   0.629    -.1737173    .2859412
    chieftanod |          0  (omitted)
         age_e |   .0095896   .0066746     1.44   0.154    -.0036769    .0228561
   education_e |   .0540693   .0546438     0.99   0.325    -.0545412    .1626798
    employed_e |  -.0414846   .0334796    -1.24   0.219     -.108029    .0250598
      income_e |  -5.98e-06   4.45e-06    -1.34   0.183    -.0000148    2.86e-06
reside_years_e |  -.0008791   .0043484    -0.20   0.840     -.009522    .0077638
        male_e |   .0786824   .1709034     0.46   0.646    -.2610067    .4183715
 assets_roof_e |  -.0021978   .0067157    -0.33   0.744    -.0155459    .0111503
years_served_e |   .0004067   .0094583     0.04   0.966    -.0183927    .0192061
c10_population |  -.0000464   .0001083    -0.43   0.669    -.0002617    .0001689
      c10_male |     7.2268   3.427599     2.11   0.038      .414076    14.03952
    c10_hhsize |   .1335161   .1721918     0.78   0.440    -.2087337    .4757659
       c10_ofw |   1.921551   4.428546     0.43   0.665    -6.880663    10.72376
 c10_education |   .1568624   .3521012     0.45   0.657     -.542977    .8567017
  c10_age18_39 |   1.088563   1.260163     0.86   0.390    -1.416148    3.593273
 c10_ms_single |   .3749913   2.122784     0.18   0.860    -3.844272    4.594255
  c10_catholic |   2.519636   1.295183     1.95   0.055    -.0546801    5.093952
        c10_ip |  -3.106051   3.666007    -0.85   0.399    -10.39264    4.180535
 c10_home_good |   .2486027   4.344002     0.06   0.954    -8.385571    8.882776
      npa_2015 |  -.1327733   .1112793    -1.19   0.236    -.3539529    .0884063
      dist_mps |  -.0409199   .0188049    -2.18   0.032    -.0782967   -.0035431
  acrime_num_m |   .0037772   .0049956     0.76   0.452    -.0061522    .0137065
  psm2_z_wmiss |   .0132129   .0642695     0.21   0.838    -.1145297    .1409555
   ds2_z_wmiss |   .0256153   .0462773     0.55   0.581    -.0663658    .1175965
 grit2_z_wmiss |   .1490381   .0639814     2.33   0.022     .0218682     .276208
  bfi2_z_wmiss |  -.1121703   .0702043    -1.60   0.114     -.251709    .0273684
         _cons |  -6.791893   3.519754    -1.93   0.057    -13.78779    .2039995
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    87) =    0.90
            Prob > F =    0.4463

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polcaseser~e |        283    1.491166    .6756345         -1          2
Table_A11.tex
Table_A11.xls
dir : seeout
F-test p-value for polcaseserious: .446, Dependent variable mean: 1.49

Linear regression                               Number of obs     =        210
                                                F(38, 85)         =       1.80
                                                Prob > F          =     0.0135
                                                R-squared         =     0.1932
                                                Root MSE          =     .80473

                                     (Std. err. adjusted for 86 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polcap_timel~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |    -.08654   .1040534    -0.83   0.408    -.2934261    .1203461
    ds_z_wmiss |   .0088359   .0725506     0.12   0.903    -.1354142     .153086
  grit_z_wmiss |   .0917513   .0791703     1.16   0.250    -.0656605     .249163
   bfi_z_wmiss |   .0067457   .0904219     0.07   0.941    -.1730373    .1865287
polcap_timel~m |   .2386255   .0827147     2.88   0.005     .0741665    .4030845
        female |  -.1538486   .2476182    -0.62   0.536    -.6461799    .3384826
           age |   1.73e-06   .0209482     0.00   1.000     -.041649    .0416524
  years_served |  -.0081767   .0178232    -0.46   0.648     -.043614    .0272606
        rank_m |  -.0303596   .0913759    -0.33   0.741    -.2120393    .1513201
         educ1 |   .3525486    .444016     0.79   0.429    -.5302742    1.235371
         educ2 |          0  (omitted)
         educ3 |  -.0152997   .1525763    -0.10   0.920    -.3186623    .2880629
       captain |  -.1295815   .1855857    -0.70   0.487    -.4985756    .2394127
       kagawad |  -.1676046   .1614998    -1.04   0.302    -.4887095    .1535003
    chieftanod |          0  (omitted)
         age_e |   .0080881   .0070249     1.15   0.253    -.0058794    .0220555
   education_e |  -.0569389   .0630792    -0.90   0.369    -.1823572    .0684794
    employed_e |  -.0209423   .0503449    -0.42   0.678    -.1210416    .0791569
      income_e |  -5.05e-07   4.80e-06    -0.11   0.916      -.00001    9.03e-06
reside_years_e |   .0003223   .0042732     0.08   0.940    -.0081739    .0088185
        male_e |  -.1085873   .2388059    -0.45   0.650    -.5833974    .3662227
 assets_roof_e |   .0070535   .0046573     1.51   0.134    -.0022064    .0163134
years_served_e |  -.0212522   .0125368    -1.70   0.094    -.0461787    .0036743
c10_population |   .0001814   .0001635     1.11   0.270    -.0001437    .0005064
      c10_male |   3.516916   5.183728     0.68   0.499    -6.789724    13.82356
    c10_hhsize |    .194376   .2422475     0.80   0.425    -.2872769    .6760289
       c10_ofw |   6.930155    6.55816     1.06   0.294    -6.109224    19.96953
 c10_education |  -.5621149   .5762659    -0.98   0.332    -1.707886     .583656
  c10_age18_39 |  -.6119136   1.972346    -0.31   0.757    -4.533465    3.309638
 c10_ms_single |  -2.968076   3.101047    -0.96   0.341    -9.133789    3.197636
  c10_catholic |   1.193865   1.995327     0.60   0.551     -2.77338     5.16111
        c10_ip |  -2.504911    7.88611    -0.32   0.752    -18.18461    13.17479
 c10_home_good |  -4.735406   5.433401    -0.87   0.386    -15.53846    6.067651
      npa_2015 |  -.0173003    .165291    -0.10   0.917    -.3459431    .3113426
      dist_mps |  -.0530724   .0286417    -1.85   0.067    -.1100198     .003875
  acrime_num_m |   .0117221   .0065393     1.79   0.077    -.0012797     .024724
  psm2_z_wmiss |  -.0071374   .0946031    -0.08   0.940    -.1952338    .1809589
   ds2_z_wmiss |   .0200535     .07483     0.27   0.789    -.1287287    .1688356
 grit2_z_wmiss |   .1377735    .083247     1.65   0.102    -.0277439    .3032909
  bfi2_z_wmiss |  -.1153307   .0914231    -1.26   0.211    -.2971044     .066443
         _cons |   2.138761   5.154285     0.41   0.679    -8.109339    12.38686
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    85) =    0.57
            Prob > F =    0.6342

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polcap_tim~e |        280    1.271429    .8195012         -2          2
Table_A11.tex
Table_A11.xls
dir : seeout
F-test p-value for polcap_timely: .634, Dependent variable mean: 1.27

Linear regression                               Number of obs     =        190
                                                F(38, 81)         =       6.28
                                                Prob > F          =     0.0000
                                                R-squared         =     0.2326
                                                Root MSE          =      .9123

                                     (Std. err. adjusted for 82 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polint_corru~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0337443   .1084073     0.31   0.756    -.1819523    .2494408
    ds_z_wmiss |  -.1554173   .1047859    -1.48   0.142    -.3639084    .0530738
  grit_z_wmiss |  -.1222799   .1022846    -1.20   0.235    -.3257942    .0812344
   bfi_z_wmiss |    .050694   .1020034     0.50   0.621    -.1522609    .2536488
polint_corru~m |    .235606   .0831955     2.83   0.006     .0700731    .4011389
        female |   .0761631   .2923955     0.26   0.795    -.5056123    .6579384
           age |  -.0015885    .022206    -0.07   0.943    -.0457716    .0425945
  years_served |  -.0029362   .0221732    -0.13   0.895     -.047054    .0411816
        rank_m |  -.0017772   .1163955    -0.02   0.988    -.2333676    .2298133
         educ1 |   -.256975   .6462333    -0.40   0.692    -1.542777    1.028827
         educ2 |          0  (omitted)
         educ3 |  -.0356234   .1845884    -0.19   0.847    -.4028965    .3316496
       captain |   .3134115   .2014216     1.56   0.124    -.0873543    .7141773
       kagawad |   .1897795    .194806     0.97   0.333    -.1978233    .5773822
    chieftanod |          0  (omitted)
         age_e |   .0282365   .0102042     2.77   0.007     .0079334    .0485397
   education_e |   .0555185    .060117     0.92   0.358    -.0640956    .1751325
    employed_e |   .0578376   .0497377     1.16   0.248    -.0411249    .1568001
      income_e |  -3.11e-07   2.32e-06    -0.13   0.894    -4.93e-06    4.31e-06
reside_years_e |  -.0091309   .0070203    -1.30   0.197    -.0230992    .0048373
        male_e |   .0279287   .2967319     0.09   0.925    -.5624748    .6183322
 assets_roof_e |   .0088655   .0058215     1.52   0.132    -.0027175    .0204485
years_served_e |  -.0163092   .0126248    -1.29   0.200    -.0414286    .0088102
c10_population |   .0001472   .0002209     0.67   0.507    -.0002923    .0005867
      c10_male |   8.100266    6.50184     1.25   0.216    -4.836357    21.03689
    c10_hhsize |   .4044863   .3350749     1.21   0.231    -.2622076     1.07118
       c10_ofw |  -1.512761   8.059039    -0.19   0.852    -17.54772     14.5222
 c10_education |    .502602    .712464     0.71   0.483    -.9149778    1.920182
  c10_age18_39 |   -5.87441   2.182612    -2.69   0.009    -10.21712   -1.531698
 c10_ms_single |  -10.19549    3.84249    -2.65   0.010    -17.84084   -2.550141
  c10_catholic |   3.523979   2.706983     1.30   0.197    -1.862069    8.910027
        c10_ip |  -.4256983   7.182414    -0.06   0.953    -14.71645    13.86505
 c10_home_good |  -10.40718    8.99457    -1.16   0.251    -28.30355    7.489191
      npa_2015 |   .1633093   .1960909     0.83   0.407    -.2268502    .5534687
      dist_mps |  -.0053195   .0381883    -0.14   0.890    -.0813021    .0706632
  acrime_num_m |   .0041749   .0110889     0.38   0.708    -.0178885    .0262384
  psm2_z_wmiss |   .0601791   .0992262     0.61   0.546    -.1372499    .2576081
   ds2_z_wmiss |   .0846817   .1043389     0.81   0.419      -.12292    .2922835
 grit2_z_wmiss |   .0718183   .1114986     0.64   0.521    -.1500289    .2936655
  bfi2_z_wmiss |  -.1249406   .1297265    -0.96   0.338    -.3830556    .1331745
         _cons |   1.426241   7.000848     0.20   0.839    -12.50325    15.35573
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    81) =    1.13
            Prob > F =    0.3405

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polint_cor~e |        272    3.231618    .9260639          0          4
Table_A11.tex
Table_A11.xls
dir : seeout
F-test p-value for polint_corrupt_rc: .34, Dependent variable mean: 3.23

Linear regression                               Number of obs     =        213
                                                F(38, 87)         =       1.98
                                                Prob > F          =     0.0046
                                                R-squared         =     0.2391
                                                Root MSE          =     .74925

                                     (Std. err. adjusted for 88 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polint_quali~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.1558585   .0882766    -1.77   0.081    -.3313177    .0196007
    ds_z_wmiss |  -.0686126   .0600345    -1.14   0.256    -.1879378    .0507125
  grit_z_wmiss |   .2164888   .0783707     2.76   0.007     .0607186    .3722591
   bfi_z_wmiss |  -.1006476   .0784532    -1.28   0.203    -.2565818    .0552865
polint_quali~m |   .2285129   .0703136     3.25   0.002      .088757    .3682688
        female |   .2052874   .2457858     0.84   0.406    -.2832386    .6938133
           age |   .0045404   .0144637     0.31   0.754    -.0242077    .0332885
  years_served |  -.0218761   .0157913    -1.39   0.169     -.053263    .0095108
        rank_m |  -.0058595   .0740145    -0.08   0.937    -.1529714    .1412523
         educ1 |    .613865   .2642696     2.32   0.023     .0886005    1.139129
         educ2 |          0  (omitted)
         educ3 |  -.3411099    .190279    -1.79   0.076      -.71931    .0370901
       captain |   .0155691    .158227     0.10   0.922    -.2989243    .3300625
       kagawad |   .0815253   .1464009     0.56   0.579    -.2094624    .3725131
    chieftanod |          0  (omitted)
         age_e |  -.0033773   .0071756    -0.47   0.639    -.0176395     .010885
   education_e |  -.0219325    .058332    -0.38   0.708    -.1378736    .0940086
    employed_e |   -.024242    .046015    -0.53   0.600    -.1157017    .0672177
      income_e |   1.96e-06   4.07e-06     0.48   0.632    -6.13e-06      .00001
reside_years_e |   .0019473   .0038341     0.51   0.613    -.0056733    .0095679
        male_e |  -.1482052   .2356609    -0.63   0.531    -.6166069    .3201964
 assets_roof_e |   .0044816   .0047331     0.95   0.346    -.0049259    .0138891
years_served_e |  -.0086062   .0117089    -0.74   0.464    -.0318789    .0146666
c10_population |   .0001824   .0001861     0.98   0.330    -.0001876    .0005524
      c10_male |  -7.693606   5.533782    -1.39   0.168     -18.6926    3.305385
    c10_hhsize |   .2050527   .2285007     0.90   0.372    -.2491171    .6592225
       c10_ofw |   6.348765   5.270208     1.20   0.232    -4.126345    16.82387
 c10_education |  -.5887944    .479035    -1.23   0.222    -1.540928    .3633396
  c10_age18_39 |   1.155399   1.937748     0.60   0.553    -2.696084    5.006883
 c10_ms_single |   -1.75088   2.842517    -0.62   0.540     -7.40069    3.898929
  c10_catholic |   3.301829   2.087227     1.58   0.117    -.8467617    7.450419
        c10_ip |   2.561311   6.532107     0.39   0.696    -10.42196    15.54458
 c10_home_good |  -6.214511   5.254198    -1.18   0.240     -16.6578    4.228777
      npa_2015 |    .046627   .1329933     0.35   0.727    -.2177116    .3109656
      dist_mps |  -.0291641   .0232971    -1.25   0.214    -.0754697    .0171414
  acrime_num_m |   .0056751   .0062883     0.90   0.369    -.0068235    .0181737
  psm2_z_wmiss |   .1113509   .0841463     1.32   0.189    -.0558989    .2786008
   ds2_z_wmiss |   .0579681   .0752201     0.77   0.443    -.0915401    .2074763
 grit2_z_wmiss |  -.0004375   .0841312    -0.01   0.996    -.1676572    .1667823
  bfi2_z_wmiss |   .0067148   .0969207     0.07   0.945    -.1859257    .1993552
         _cons |   4.788636   5.222348     0.92   0.362    -5.591347    15.16862
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    87) =    3.60
            Prob > F =    0.0166

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polint_qua~e |        282    1.283688    .7943416         -2          2
Table_A11.tex
Table_A11.xls
dir : seeout
F-test p-value for polint_quality: .017, Dependent variable mean: 1.28

Linear regression                               Number of obs     =        215
                                                F(38, 87)         =       3.94
                                                Prob > F          =     0.0000
                                                R-squared         =     0.1106
                                                Root MSE          =     .62576

                                     (Std. err. adjusted for 88 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
 satis_trust_e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.0606166   .0587651    -1.03   0.305    -.1774187    .0561855
    ds_z_wmiss |   .0961519   .0467989     2.05   0.043      .003134    .1891699
  grit_z_wmiss |    .080471   .0561589     1.43   0.155    -.0311509     .192093
   bfi_z_wmiss |  -.0210744   .0605064    -0.35   0.728    -.1413375    .0991886
 satis_trust_m |   .0302755   .0639383     0.47   0.637    -.0968087    .1573597
        female |   .0678468   .2003548     0.34   0.736    -.3303801    .4660737
           age |   .0081256   .0136608     0.59   0.554    -.0190267    .0352779
  years_served |  -.0137559   .0134156    -1.03   0.308     -.040421    .0129091
        rank_m |   .0322502   .0567092     0.57   0.571    -.0804655    .1449658
         educ1 |   .5229776   .1485017     3.52   0.001     .2278145    .8181408
         educ2 |          0  (omitted)
         educ3 |  -.0014076   .1372953    -0.01   0.992    -.2742969    .2714816
       captain |  -.0273919   .1502302    -0.18   0.856    -.3259907     .271207
       kagawad |  -.0357619   .1262446    -0.28   0.778    -.2866867    .2151629
    chieftanod |          0  (omitted)
         age_e |   .0079431   .0063282     1.26   0.213    -.0046349     .020521
   education_e |   -.009012   .0497266    -0.18   0.857    -.1078491     .089825
    employed_e |  -.0516652   .0361871    -1.43   0.157     -.123591    .0202605
      income_e |   7.45e-08   1.51e-06     0.05   0.961    -2.93e-06    3.08e-06
reside_years_e |  -.0017504   .0036028    -0.49   0.628    -.0089113    .0054105
        male_e |   .0702203   .1927851     0.36   0.717     -.312961    .4534016
 assets_roof_e |   .0009536   .0033583     0.28   0.777    -.0057214    .0076285
years_served_e |   .0004972   .0089495     0.06   0.956    -.0172908    .0182853
c10_population |   .0000282    .000136     0.21   0.836    -.0002422    .0002985
      c10_male |   -2.31793   4.068431    -0.57   0.570    -10.40438    5.768518
    c10_hhsize |   .0970094   .1783196     0.54   0.588    -.2574201    .4514389
       c10_ofw |  -1.794151   4.835544    -0.37   0.712    -11.40532    7.817016
 c10_education |  -.0829933   .4305043    -0.19   0.848    -.9386672    .7726807
  c10_age18_39 |   2.374309   1.317402     1.80   0.075    -.2441704    4.992788
 c10_ms_single |  -.6392885   2.331551    -0.27   0.785    -5.273498    3.994921
  c10_catholic |   1.604187   1.391928     1.15   0.252    -1.162422    4.370795
        c10_ip |   .5064053   4.503197     0.11   0.911    -8.444186    9.456997
 c10_home_good |  -.4402291   4.323012    -0.10   0.919    -9.032683    8.152225
      npa_2015 |  -.0821889   .1202773    -0.68   0.496     -.321253    .1568752
      dist_mps |  -.0065041   .0164921    -0.39   0.694     -.039284    .0262759
  acrime_num_m |  -.0029112   .0046944    -0.62   0.537    -.0122419    .0064195
  psm2_z_wmiss |  -.0000789   .0526557    -0.00   0.999    -.1047378    .1045799
   ds2_z_wmiss |   .0507985   .0447443     1.14   0.259    -.0381356    .1397326
 grit2_z_wmiss |   .0129571   .0750322     0.17   0.863    -.1361776    .1620918
  bfi2_z_wmiss |   .0149497     .06957     0.21   0.830    -.1233282    .1532275
         _cons |  -.8490874   4.192376    -0.20   0.840    -9.181889    7.483714
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    87) =    1.81
            Prob > F =    0.1510

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
satis_trus~e |        283    1.515901     .609262          0          2
Table_A11.tex
Table_A11.xls
dir : seeout
F-test p-value for satis_trust: .151, Dependent variable mean: 1.52

Linear regression                               Number of obs     =        214
                                                F(38, 87)         =       2.27
                                                Prob > F          =     0.0009
                                                R-squared         =     0.1670
                                                Root MSE          =     .70888

                                     (Std. err. adjusted for 88 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
satis_genera~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0058346   .0677492     0.09   0.932    -.1288244    .1404935
    ds_z_wmiss |   .0006712   .0623988     0.01   0.991    -.1233532    .1246956
  grit_z_wmiss |   .0617501   .0619582     1.00   0.322    -.0613985    .1848986
   bfi_z_wmiss |   .0355922   .0728744     0.49   0.626    -.1092535    .1804378
satis_genera~m |   .1028857   .0665047     1.55   0.125    -.0292995    .2350709
        female |   .1832041   .2117822     0.87   0.389    -.2377359    .6041442
           age |   .0143634   .0147281     0.98   0.332    -.0149104    .0436371
  years_served |  -.0131444   .0143912    -0.91   0.364    -.0417485    .0154597
        rank_m |  -.0374847   .0688655    -0.54   0.588    -.1743624     .099393
         educ1 |   .5466832   .2569384     2.13   0.036     .0359903    1.057376
         educ2 |          0  (omitted)
         educ3 |   .0624585   .1585076     0.39   0.695    -.2525924    .3775095
       captain |   .0062143   .1669697     0.04   0.970     -.325656    .3380846
       kagawad |  -.2045035   .1404102    -1.46   0.149     -.483584     .074577
    chieftanod |          0  (omitted)
         age_e |   .0083157   .0067303     1.24   0.220    -.0050616     .021693
   education_e |   .0102366   .0523887     0.20   0.846    -.0938917    .1143649
    employed_e |   .0135298   .0377064     0.36   0.721    -.0614157    .0884754
      income_e |  -2.92e-06   2.20e-06    -1.32   0.189    -7.29e-06    1.46e-06
reside_years_e |  -.0008936   .0037426    -0.24   0.812    -.0083323    .0065451
        male_e |    .324403   .2200481     1.47   0.144    -.1129665    .7617724
 assets_roof_e |   .0077889    .006192     1.26   0.212    -.0045183    .0200962
years_served_e |  -.0010457   .0111961    -0.09   0.926    -.0232992    .0212078
c10_population |   .0001659   .0001561     1.06   0.291    -.0001444    .0004763
      c10_male |   3.603959   4.332535     0.83   0.408    -5.007424    12.21534
    c10_hhsize |   -.162096   .1938699    -0.84   0.405    -.5474334    .2232414
       c10_ofw |   -.100616   6.852169    -0.01   0.988    -13.72004    13.51881
 c10_education |  -.5111806   .4385121    -1.17   0.247    -1.382771    .3604096
  c10_age18_39 |  -.6875591   1.656415    -0.42   0.679    -3.979863    2.604745
 c10_ms_single |  -.0273975   2.230179    -0.01   0.990    -4.460119    4.405324
  c10_catholic |   .7397289   1.564766     0.47   0.638    -2.370413    3.849871
        c10_ip |    6.21681   5.283505     1.18   0.243    -4.284727    16.71835
 c10_home_good |  -4.289048   4.958423    -0.87   0.389    -14.14445    5.566355
      npa_2015 |   .0959296   .1273214     0.75   0.453    -.1571354    .3489947
      dist_mps |  -.0307048   .0217728    -1.41   0.162    -.0739807     .012571
  acrime_num_m |   .0114768   .0047292     2.43   0.017     .0020771    .0208765
  psm2_z_wmiss |   .1379904   .0776005     1.78   0.079    -.0162491    .2922299
   ds2_z_wmiss |   .0689122   .0542178     1.27   0.207    -.0388515     .176676
 grit2_z_wmiss |   .0831428   .0680984     1.22   0.225    -.0522101    .2184957
  bfi2_z_wmiss |   -.167356   .0822458    -2.03   0.045    -.3308284   -.0038835
         _cons |   1.635002   4.515737     0.36   0.718    -7.340515    10.61052
--------------------------------------------------------------------------------

 ( 1)  psm_z_wmiss - ds_z_wmiss = 0
 ( 2)  psm_z_wmiss - grit_z_wmiss = 0
 ( 3)  psm_z_wmiss - bfi_z_wmiss = 0

       F(  3,    87) =    0.25
            Prob > F =    0.8589

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
satis_gene~e |        284    1.330986    .7492925         -1          2
Table_A11.tex
Table_A11.xls
dir : seeout
F-test p-value for satis_general: .859, Dependent variable mean: 1.33

. 
. 
. ************
. * Table A6 *
. ************
. 
. foreach i in responsive_act polcaseserious polcap_timely polint_corrupt_rc poli
> nt_quality satis_trust satis_general {
  2. 
.     // Run the regression
.     reg `i'_e psm_z_wmiss ds_z_wmiss grit_z_wmiss `i'_m ///
>     extroversion_z_wmiss agreeable_z_wmiss conscientious_z_wmiss neuroticism_z_
> wmiss openness_z_wmiss ///
>     $controls_bgy, vce(cl bgy)
  3.     
.     // Perform the F-test
.     test extroversion_z_wmiss = agreeable_z_wmiss = conscientious_z_wmiss = neu
> roticism_z_wmiss = openness_z_wmiss
  4.     
.     // Capture the p-value from the F-test and round it to 3 decimal points
.     local p_value = round(r(p), 0.001)
  5.     
.     // Calculate the mean of the dependent variable and round it to 2 decimal p
> oints
.     sum `i'_e
  6.     local depvar_mean = round(r(mean), 0.01)
  7.     
.     // Store the estimates for this regression
.     estimates store reg_`i'
  8. 
.     // Output the regression table, only keeping the specified variables, hidin
> g the constant, and using labels
.     if "`i'" == "responsive_act" {
  9.         outreg2 [reg_`i'] using "Table_A6.xls", replace tex dec(3) ///
>         keep(extroversion_z_wmiss agreeable_z_wmiss conscientious_z_wmiss neuro
> ticism_z_wmiss openness_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 10.     }
 11.     else {
 12.         outreg2 [reg_`i'] using "Table_A6.xls", append tex dec(3) ///
>         keep(extroversion_z_wmiss agreeable_z_wmiss conscientious_z_wmiss neuro
> ticism_z_wmiss openness_z_wmiss) ///
>         addstat(F-test p-value, `p_value', Dep. Var. Mean, `depvar_mean') label
 13.     }
 14. 
.     // Optionally display the rounded p-value and dependent variable mean in th
> e console for confirmation
.     di "F-test p-value for `i': `p_value', Dependent variable mean: `depvar_mea
> n'"
 15. }

Linear regression                               Number of obs     =        235
                                                F(22, 93)         =       2.18
                                                Prob > F          =     0.0052
                                                R-squared         =     0.1347
                                                Root MSE          =     .71647

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
responsive_a~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0003618    .078944     0.00   0.996    -.1564054     .157129
    ds_z_wmiss |  -.0535029   .0637615    -0.84   0.404    -.1801206    .0731147
  grit_z_wmiss |   .1512212   .0720713     2.10   0.039     .0081019    .2943405
responsive_a~m |   .0706921   .0751069     0.94   0.349    -.0784554    .2198396
extroversion~s |   .1183703   .0637231     1.86   0.066     -.008171    .2449117
agreeable_z_~s |  -.0403441   .0710658    -0.57   0.572    -.1814668    .1007786
conscientiou~s |   .0015034   .0690082     0.02   0.983    -.1355331    .1385399
neuroticism_~s |  -.0182341   .0506155    -0.36   0.719    -.1187465    .0822783
openness_z_w~s |  -.0472562   .0686173    -0.69   0.493    -.1835165    .0890041
c10_population |  -.0000957    .000112    -0.85   0.395    -.0003181    .0001266
      c10_male |    2.75228    4.04965     0.68   0.498    -5.289522    10.79408
    c10_hhsize |  -.2218164   .1857059    -1.19   0.235    -.5905915    .1469587
       c10_ofw |   8.939685   4.399894     2.03   0.045     .2023675      17.677
 c10_education |   .3608436   .3768004     0.96   0.341    -.3874073    1.109094
  c10_age18_39 |   2.968844   1.383339     2.15   0.034     .2218074     5.71588
 c10_ms_single |  -.0787341   2.213952    -0.04   0.972    -4.475205    4.317736
  c10_catholic |  -.7610131   1.413154    -0.54   0.592    -3.567257     2.04523
        c10_ip |  -5.805403   4.571319    -1.27   0.207    -14.88314    3.272331
 c10_home_good |   .2606651   4.303483     0.06   0.952      -8.2852     8.80653
      npa_2015 |   .0031237   .1179147     0.03   0.979    -.2310315    .2372789
      dist_mps |  -.0517128   .0165977    -3.12   0.002    -.0846725   -.0187531
  acrime_num_m |   .0071285    .006352     1.12   0.265    -.0054852    .0197423
         _cons |  -.7861083   3.957813    -0.20   0.843     -8.64554    7.073323
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    93) =    0.88
            Prob > F =    0.4811

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
responsive~e |        283    1.388693    .7467277         -1          2
Table_A6.tex
Table_A6.xls
dir : seeout
F-test p-value for responsive_act: .481, Dependent variable mean: 1.39

Linear regression                               Number of obs     =        236
                                                F(22, 93)         =       1.80
                                                Prob > F          =     0.0281
                                                R-squared         =     0.1035
                                                Root MSE          =     .66414

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polcaseserio~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0521755   .0779772     0.67   0.505    -.1026718    .2070228
    ds_z_wmiss |  -.0790641   .0596236    -1.33   0.188    -.1974648    .0393365
  grit_z_wmiss |   .0560223   .0651231     0.86   0.392    -.0732994    .1853439
polcaseserio~m |   .1163978   .0598284     1.95   0.055    -.0024094    .2352051
extroversion~s |   .0588608   .0590977     1.00   0.322    -.0584954     .176217
agreeable_z_~s |  -.1338019   .0678855    -1.97   0.052    -.2686091    .0010053
conscientiou~s |   .0845786   .0599064     1.41   0.161    -.0343837    .2035409
neuroticism_~s |   -.009775   .0548698    -0.18   0.859    -.1187354    .0991855
openness_z_w~s |   .0144499   .0582841     0.25   0.805    -.1012908    .1301906
c10_population |   -.000086   .0000946    -0.91   0.365    -.0002739    .0001018
      c10_male |   4.783858   3.738236     1.28   0.204    -2.639537    12.20725
    c10_hhsize |   .0398243   .1621955     0.25   0.807    -.2822638    .3619124
       c10_ofw |   6.591481   3.983613     1.65   0.101    -1.319186    14.50215
 c10_education |   .2219557   .3280244     0.68   0.500    -.4294357    .8733471
  c10_age18_39 |   1.589675   1.039684     1.53   0.130    -.4749301    3.654281
 c10_ms_single |  -1.090414   1.884631    -0.58   0.564    -4.832917    2.652088
  c10_catholic |    .563961   1.131338     0.50   0.619    -1.682653    2.810575
        c10_ip |  -2.343099   3.804228    -0.62   0.539    -9.897542    5.211345
 c10_home_good |   .7920435   3.776169     0.21   0.834     -6.70668    8.290767
      npa_2015 |   -.067738   .1106364    -0.61   0.542      -.28744    .1519639
      dist_mps |  -.0493535    .014559    -3.39   0.001    -.0782648   -.0204423
  acrime_num_m |   .0028671   .0050468     0.57   0.571    -.0071549     .012889
         _cons |  -2.785708   3.514635    -0.79   0.430    -9.765078    4.193661
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    93) =    2.26
            Prob > F =    0.0688

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polcaseser~e |        283    1.491166    .6756345         -1          2
Table_A6.tex
Table_A6.xls
dir : seeout
F-test p-value for polcaseserious: .069, Dependent variable mean: 1.49

Linear regression                               Number of obs     =        231
                                                F(22, 92)         =       2.17
                                                Prob > F          =     0.0056
                                                R-squared         =     0.1599
                                                Root MSE          =     .78018

                                     (Std. err. adjusted for 93 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polcap_timel~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.0004145   .1072504    -0.00   0.997    -.2134231     .212594
    ds_z_wmiss |  -.0132538   .0759398    -0.17   0.862    -.1640768    .1375693
  grit_z_wmiss |   .0896243   .0861859     1.04   0.301    -.0815482    .2607969
polcap_timel~m |   .2396816   .0650658     3.68   0.000     .1104554    .3689078
extroversion~s |   .0209862    .095841     0.22   0.827    -.1693623    .2113347
agreeable_z_~s |  -.1934639   .0876853    -2.21   0.030    -.3676145   -.0193133
conscientiou~s |   .1350063    .123549     1.09   0.277    -.1103726    .3803853
neuroticism_~s |   .0014914   .0914255     0.02   0.987    -.1800877    .1830704
openness_z_w~s |  -.0261385   .0842386    -0.31   0.757    -.1934436    .1411666
c10_population |   .0000893   .0001384     0.65   0.520    -.0001855    .0003641
      c10_male |   1.251636   5.224637     0.24   0.811    -9.124944    11.62821
    c10_hhsize |  -.0010386   .2355845    -0.00   0.996    -.4689297    .4668524
       c10_ofw |   5.923148   5.532844     1.07   0.287    -5.065558    16.91185
 c10_education |   -.429739    .498028    -0.86   0.390    -1.418865    .5593876
  c10_age18_39 |   1.012227   1.590235     0.64   0.526    -2.146118    4.170571
 c10_ms_single |  -2.159744   2.908179    -0.74   0.460    -7.935639    3.616151
  c10_catholic |   .5505791   1.893177     0.29   0.772    -3.209435    4.310593
        c10_ip |  -2.244165   6.974645    -0.32   0.748    -16.09641    11.60808
 c10_home_good |  -6.046075   5.381802    -1.12   0.264     -16.7348    4.642648
      npa_2015 |   .0117048   .1457975     0.08   0.936    -.2778617    .3012713
      dist_mps |  -.0601676   .0242063    -2.49   0.015    -.1082435   -.0120918
  acrime_num_m |   .0095366     .00692     1.38   0.172    -.0042071    .0232803
         _cons |   3.069001   4.852203     0.63   0.529    -6.567892    12.70589
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    92) =    1.27
            Prob > F =    0.2881

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polcap_tim~e |        280    1.271429    .8195012         -2          2
Table_A6.tex
Table_A6.xls
dir : seeout
F-test p-value for polcap_timely: .288, Dependent variable mean: 1.27

Linear regression                               Number of obs     =        211
                                                F(22, 89)         =       1.78
                                                Prob > F          =     0.0307
                                                R-squared         =     0.1378
                                                Root MSE          =     .90396

                                     (Std. err. adjusted for 90 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polint_corru~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .0767529   .1039995     0.74   0.462    -.1298919    .2833977
    ds_z_wmiss |  -.1794598   .0863425    -2.08   0.041    -.3510204   -.0078991
  grit_z_wmiss |  -.0502434    .091223    -0.55   0.583    -.2315016    .1310148
polint_corru~m |   .1572302   .0668069     2.35   0.021     .0244863     .289974
extroversion~s |   .1283823   .1038974     1.24   0.220    -.0780597    .3348242
agreeable_z_~s |  -.0477723   .1208268    -0.40   0.694    -.2878526    .1923081
conscientiou~s |  -.0683697   .1309971    -0.52   0.603    -.3286583    .1919188
neuroticism_~s |  -.1234344   .0971862    -1.27   0.207    -.3165414    .0696726
openness_z_w~s |   .0768175   .0924166     0.83   0.408    -.1068123    .2604473
c10_population |  -.0000474   .0001469    -0.32   0.748    -.0003392    .0002444
      c10_male |   8.818564   5.420539     1.63   0.107    -1.951932    19.58906
    c10_hhsize |   -.039199   .2949903    -0.13   0.895    -.6253385    .5469405
       c10_ofw |  -2.261844   5.100488    -0.44   0.659     -12.3964    7.872717
 c10_education |   .4558281   .5803728     0.79   0.434    -.6973603    1.609016
  c10_age18_39 |   -4.43623   1.809549    -2.45   0.016    -8.031766   -.8406942
 c10_ms_single |  -7.655723   3.106389    -2.46   0.016    -13.82805   -1.483394
  c10_catholic |   1.357211   2.512527     0.54   0.590    -3.635127    6.349548
        c10_ip |  -.5485495   6.572141    -0.08   0.934    -13.60725    12.51015
 c10_home_good |  -13.73378   7.255679    -1.89   0.062    -28.15066    .6831027
      npa_2015 |   .1021802   .1759846     0.58   0.563    -.2474974    .4518579
      dist_mps |  -.0408449   .0296551    -1.38   0.172     -.099769    .0180791
  acrime_num_m |   .0098704   .0092162     1.07   0.287     -.008442    .0281829
         _cons |    6.25011   5.901064     1.06   0.292    -5.475179     17.9754
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    89) =    0.98
            Prob > F =    0.4241

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polint_cor~e |        272    3.231618    .9260639          0          4
Table_A6.tex
Table_A6.xls
dir : seeout
F-test p-value for polint_corrupt_rc: .424, Dependent variable mean: 3.23

Linear regression                               Number of obs     =        234
                                                F(22, 93)         =       3.45
                                                Prob > F          =     0.0000
                                                R-squared         =     0.2052
                                                Root MSE          =     .73929

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
polint_quali~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.0793483   .0817271    -0.97   0.334    -.2416421    .0829454
    ds_z_wmiss |  -.0864286   .0554755    -1.56   0.123     -.196592    .0237348
  grit_z_wmiss |   .1367891   .0738519     1.85   0.067    -.0098661    .2834444
polint_quali~m |    .236404   .0646162     3.66   0.000      .108089    .3647191
extroversion~s |   .0803202   .0879915     0.91   0.364    -.0944134    .2550538
agreeable_z_~s |  -.2036617   .0814515    -2.50   0.014    -.3654082   -.0419153
conscientiou~s |   .0334755   .0843478     0.40   0.692    -.1340224    .2009735
neuroticism_~s |   -.008374   .0898342    -0.09   0.926    -.1867669    .1700188
openness_z_w~s |   .0298624    .069729     0.43   0.669    -.1086056    .1683305
c10_population |  -.0000748   .0001423    -0.53   0.601    -.0003574    .0002079
      c10_male |  -6.358434    4.47795    -1.42   0.159    -15.25076    2.533888
    c10_hhsize |  -.1441768   .2211069    -0.65   0.516    -.5832513    .2948977
       c10_ofw |   6.913769   5.490588     1.26   0.211    -3.989451    17.81699
 c10_education |  -.2399864    .438417    -0.55   0.585    -1.110596    .6306228
  c10_age18_39 |   2.990229   1.755229     1.70   0.092     -.495309    6.475766
 c10_ms_single |  -1.765855   2.476325    -0.71   0.478    -6.683345    3.151636
  c10_catholic |   3.507951   2.125181     1.65   0.102    -.7122375    7.728139
        c10_ip |   2.165357   4.751379     0.46   0.650     -7.26994    11.60065
 c10_home_good |  -7.129813   4.598577    -1.55   0.124    -16.26168     2.00205
      npa_2015 |   .0411389   .1202724     0.34   0.733    -.1976982    .2799759
      dist_mps |  -.0497595   .0211541    -2.35   0.021    -.0917674   -.0077515
  acrime_num_m |   .0055883   .0065275     0.86   0.394     -.007374    .0185507
         _cons |   3.459633   4.720022     0.73   0.465    -5.913396    12.83266
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    93) =    1.93
            Prob > F =    0.1125

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
polint_qua~e |        282    1.283688    .7943416         -2          2
Table_A6.tex
Table_A6.xls
dir : seeout
F-test p-value for polint_quality: .112, Dependent variable mean: 1.28

Linear regression                               Number of obs     =        236
                                                F(22, 93)         =       1.11
                                                Prob > F          =     0.3557
                                                R-squared         =     0.0876
                                                Root MSE          =      .6101

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
 satis_trust_e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |  -.0381432   .0519542    -0.73   0.465    -.1413139    .0650276
    ds_z_wmiss |   .0474625   .0451799     1.05   0.296    -.0422559    .1371808
  grit_z_wmiss |   .0470546   .0473087     0.99   0.322    -.0468911    .1410003
 satis_trust_m |    .068787   .0660999     1.04   0.301    -.0624744    .2000484
extroversion~s |   .0853691   .0626442     1.36   0.176    -.0390298     .209768
agreeable_z_~s |  -.0876346   .0611061    -1.43   0.155    -.2089792    .0337101
conscientiou~s |   .0787787   .0675394     1.17   0.246    -.0553411    .2128985
neuroticism_~s |  -.0772106   .0604599    -1.28   0.205     -.197272    .0428508
openness_z_w~s |  -.0178459   .0507551    -0.35   0.726    -.1186354    .0829436
c10_population |   .0000243   .0001164     0.21   0.835    -.0002069    .0002555
      c10_male |  -.3702613     3.7658    -0.10   0.922    -7.848393     7.10787
    c10_hhsize |  -.0393762   .1603798    -0.25   0.807    -.3578588    .2791064
       c10_ofw |   2.576599   3.683577     0.70   0.486    -4.738254    9.891453
 c10_education |  -.2091874   .3876682    -0.54   0.591    -.9790196    .5606449
  c10_age18_39 |   1.222766   1.045944     1.17   0.245    -.8542721    3.299803
 c10_ms_single |  -1.323282   1.721685    -0.77   0.444    -4.742207    2.095643
  c10_catholic |   .8141598   1.139135     0.71   0.477    -1.447937    3.076257
        c10_ip |   .7635148   3.288147     0.23   0.817    -5.766093    7.293123
 c10_home_good |  -2.297084   3.680686    -0.62   0.534    -9.606196    5.012028
      npa_2015 |  -.0235227   .1226577    -0.19   0.848    -.2670965    .2200512
      dist_mps |  -.0229219   .0135783    -1.69   0.095    -.0498857    .0040418
  acrime_num_m |   .0031419   .0049695     0.63   0.529    -.0067266    .0130103
         _cons |   1.963184   3.424536     0.57   0.568    -4.837266    8.763634
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    93) =    1.87
            Prob > F =    0.1222

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
satis_trus~e |        283    1.515901     .609262          0          2
Table_A6.tex
Table_A6.xls
dir : seeout
F-test p-value for satis_trust: .122, Dependent variable mean: 1.52

Linear regression                               Number of obs     =        235
                                                F(22, 93)         =       2.34
                                                Prob > F          =     0.0026
                                                R-squared         =     0.1528
                                                Root MSE          =      .6947

                                     (Std. err. adjusted for 94 clusters in bgy)
--------------------------------------------------------------------------------
               |               Robust
satis_genera~e | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
---------------+----------------------------------------------------------------
   psm_z_wmiss |   .1246262    .071496     1.74   0.085    -.0173506    .2666031
    ds_z_wmiss |  -.0790293   .0661698    -1.19   0.235    -.2104295    .0523709
  grit_z_wmiss |   .0128701   .0557878     0.23   0.818    -.0979134    .1236536
satis_genera~m |   .1292951   .0517253     2.50   0.014     .0265789    .2320113
extroversion~s |   .0787497   .0695366     1.13   0.260    -.0593361    .2168356
agreeable_z_~s |  -.1961515   .0642988    -3.05   0.003    -.3238362   -.0684667
conscientiou~s |   .1579284   .0747048     2.11   0.037     .0095795    .3062774
neuroticism_~s |  -.0168459   .0599669    -0.28   0.779    -.1359283    .1022366
openness_z_w~s |  -.0847906   .0584776    -1.45   0.150    -.2009156    .0313344
c10_population |    .000066   .0001116     0.59   0.556    -.0001556    .0002875
      c10_male |   4.662391   4.231577     1.10   0.273    -3.740682    13.06546
    c10_hhsize |  -.2946427   .2018665    -1.46   0.148    -.6955096    .1062242
       c10_ofw |   2.728619   5.624173     0.49   0.629    -8.439874    13.89711
 c10_education |  -.1538255   .3665425    -0.42   0.676    -.8817063    .5740553
  c10_age18_39 |   .0758905   1.438986     0.05   0.958     -2.78165    2.933431
 c10_ms_single |  -1.726674   1.993627    -0.87   0.389    -5.685621    2.232274
  c10_catholic |   1.200531   1.233692     0.97   0.333    -1.249337      3.6504
        c10_ip |   -.601561   3.981719    -0.15   0.880    -8.508465    7.305343
 c10_home_good |  -3.893827   4.395597    -0.89   0.378    -12.62261    4.834957
      npa_2015 |   .1008617   .1118045     0.90   0.369    -.1211599    .3228832
      dist_mps |  -.0610759   .0191061    -3.20   0.002    -.0990169    -.023135
  acrime_num_m |   .0068863   .0053398     1.29   0.200    -.0037175    .0174901
         _cons |   .9792598    4.12982     0.24   0.813    -7.221743    9.180263
--------------------------------------------------------------------------------

 ( 1)  extroversion_z_wmiss - agreeable_z_wmiss = 0
 ( 2)  extroversion_z_wmiss - conscientious_z_wmiss = 0
 ( 3)  extroversion_z_wmiss - neuroticism_z_wmiss = 0
 ( 4)  extroversion_z_wmiss - openness_z_wmiss = 0

       F(  4,    93) =    2.87
            Prob > F =    0.0271

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
satis_gene~e |        284    1.330986    .7492925         -1          2
Table_A6.tex
Table_A6.xls
dir : seeout
F-test p-value for satis_general: .027, Dependent variable mean: 1.33

. 
. 
. *************
. * Table A12 *
. *************
. 
. // Generate the attriters variable
. gen attriters = 1 if empathy == .
(242 missing values generated)

. replace attriters = 0 if empathy != .
(242 real changes made)

. 
. // Create a matrix to store the results
. preserve

. postfile handle str20 varname mean_attriters mean_nonattriters N_attriters N_no
> nattriters diff_means pvalue using "Table_A12.dta", replace

. 
. // Loop through each variable and calculate the necessary statistics
. foreach i in captain kagawad chieftanod age_e education_e employed_e income_e /
> //
> reside_years_e male_e assets_roof_e years_served_e {
  2. 
.     // Perform t-test by attriters
.     ttest `i', by(attriters)
  3. 
.     // Capture the means, difference, and p-value
.     local mean_attriters = r(mu_1)
  4.     local mean_nonattriters = r(mu_2)
  5.     local N_attriters = r(N_1)
  6.     local N_nonattriters = r(N_2)
  7.     local diff_means = round(r(mu_1) - r(mu_2), 0.001)
  8.     local pvalue = r(p)
  9. 
.     // Post the results into the table
.     post handle ("`i'") (`mean_attriters') (`mean_nonattriters') (`N_attriters'
> ) (`N_nonattriters') (`diff_means') (`pvalue')
 10. }

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     242    .3471074    .0306651    .4770369    .2867016    .4075133
       1 |      42    .2619048    .0686651    .4450006    .1232328    .4005767
---------+--------------------------------------------------------------------
Combined |     284     .334507    .0280467    .4726507    .2793005    .3897136
---------+--------------------------------------------------------------------
    diff |            .0852027    .0789845               -.0702713    .2406766
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   1.0787
H0: diff = 0                                     Degrees of freedom =      282

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.8592         Pr(|T| > |t|) = 0.2816          Pr(T > t) = 0.1408

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     242    .2727273    .0286883    .4462848    .2162155     .329239
       1 |      42          .5    .0780869    .5060608    .3423003    .6576997
---------+--------------------------------------------------------------------
Combined |     284     .306338    .0274019    .4617856    .2524006    .3602755
---------+--------------------------------------------------------------------
    diff |           -.2272727    .0761343               -.3771363   -.0774091
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =  -2.9852
H0: diff = 0                                     Degrees of freedom =      282

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.0015         Pr(|T| > |t|) = 0.0031          Pr(T > t) = 0.9985

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     242    .3801653    .0312691    .4864333    .3185696     .441761
       1 |      42    .2380952    .0665172    .4310805    .1037611    .3724294
---------+--------------------------------------------------------------------
Combined |     284    .3591549    .0285183    .4805996    .3030199    .4152899
---------+--------------------------------------------------------------------
    diff |            .1420701    .0800324               -.0154667    .2996068
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   1.7752
H0: diff = 0                                     Degrees of freedom =      282

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.9615         Pr(|T| > |t|) = 0.0770          Pr(T > t) = 0.0385

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     242    52.33884    .6352339     9.88192    51.08752    53.59016
       1 |      42    50.92857    1.416836    9.182148    48.06721    53.78993
---------+--------------------------------------------------------------------
Combined |     284    52.13028    .5802685    9.778859    50.98809    53.27247
---------+--------------------------------------------------------------------
    diff |            1.410272    1.635354               -1.808779    4.629322
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   0.8624
H0: diff = 0                                     Degrees of freedom =      282

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.8054         Pr(|T| > |t|) = 0.3892          Pr(T > t) = 0.1946

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     242     1.85124    .0882917    1.373496    1.677318    2.025162
       1 |      42    2.119048    .2316491    1.501258    1.651223    2.586872
---------+--------------------------------------------------------------------
Combined |     284    1.890845    .0826946    1.393595     1.72807     2.05362
---------+--------------------------------------------------------------------
    diff |           -.2678079    .2328175               -.7260886    .1904727
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =  -1.1503
H0: diff = 0                                     Degrees of freedom =      282

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.1255         Pr(|T| > |t|) = 0.2510          Pr(T > t) = 0.8745

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     242    1.933884    .0859594    1.337214    1.764557    2.103212
       1 |      42    1.928571    .2111658    1.368511    1.502113    2.355029
---------+--------------------------------------------------------------------
Combined |     284    1.933099     .079481    1.339438     1.77665    2.089548
---------+--------------------------------------------------------------------
    diff |            .0053129    .2242941               -.4361902     .446816
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   0.0237
H0: diff = 0                                     Degrees of freedom =      282

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.5094         Pr(|T| > |t|) = 0.9811          Pr(T > t) = 0.4906

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     241    12627.39    1514.695    23514.39      9643.6    15611.19
       1 |      42     14283.1    2049.315    13281.08    10144.42    18421.77
---------+--------------------------------------------------------------------
Combined |     283    12873.12    1324.635    22283.82    10265.69    15480.54
---------+--------------------------------------------------------------------
    diff |           -1655.701    3731.375               -9000.697    5689.295
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =  -0.4437
H0: diff = 0                                     Degrees of freedom =      281

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.3288         Pr(|T| > |t|) = 0.6576          Pr(T > t) = 0.6712

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     239    45.26778    .9430056    14.57851    43.41008    47.12549
       1 |      42    44.57143    2.178755    14.11994    40.17134    48.97151
---------+--------------------------------------------------------------------
Combined |     281     45.1637    .8642954    14.48823    43.46236    46.86504
---------+--------------------------------------------------------------------
    diff |            .6963539    2.428051               -4.083272     5.47598
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   0.2868
H0: diff = 0                                     Degrees of freedom =      279

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.6128         Pr(|T| > |t|) = 0.7745          Pr(T > t) = 0.3872

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     239    .8953975    .0198377    .3066828    .8563177    .9344773
       1 |      41     .902439    .0469156    .3004062    .8076191    .9972589
---------+--------------------------------------------------------------------
Combined |     280    .8964286    .0182421    .3052493    .8605189    .9323383
---------+--------------------------------------------------------------------
    diff |           -.0070415    .0516902               -.1087954    .0947124
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =  -0.1362
H0: diff = 0                                     Degrees of freedom =      278

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.4459         Pr(|T| > |t|) = 0.8917          Pr(T > t) = 0.5541

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     242    4.305785    .6106427    9.499371    3.102907    5.508663
       1 |      42    3.738095    .1636529    1.060592    3.407592    4.068599
---------+--------------------------------------------------------------------
Combined |     284    4.221831    .5208659    8.777788    3.196568    5.247094
---------+--------------------------------------------------------------------
    diff |            .5676899    1.469487               -2.324865    3.460245
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   0.3863
H0: diff = 0                                     Degrees of freedom =      282

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.6502         Pr(|T| > |t|) = 0.6996          Pr(T > t) = 0.3498

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. err.   Std. dev.   [95% conf. interval]
---------+--------------------------------------------------------------------
       0 |     241    7.448133     .367028    5.697807    6.725125     8.17114
       1 |      42     4.02381     .581847      3.7708    2.848746    5.198873
---------+--------------------------------------------------------------------
Combined |     283    6.939929    .3319517    5.584292    6.286512    7.593347
---------+--------------------------------------------------------------------
    diff |            3.424323    .9128267                1.627477     5.22117
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   3.7513
H0: diff = 0                                     Degrees of freedom =      281

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.9999         Pr(|T| > |t|) = 0.0002          Pr(T > t) = 0.0001

. 
. // Close the postfile
. postclose handle

. 
. // Export the results to a CSV file
. use "Table_A12.dta", clear

. export delimited using "Table_A12.csv", replace
file Table_A12.csv saved

. restore

. 
. 
. *************
. * Table A13 *
. *************
. 
. // Run the correlation command
. corr psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss ///
> female age years_served rank_m educ1 educ2 educ3
(obs=266)

             | psm_z_~s ds_z_w~s grit_z~s bfi_z_~s   female      age years_~d
-------------+---------------------------------------------------------------
 psm_z_wmiss |   1.0000
  ds_z_wmiss |   0.1700   1.0000
grit_z_wmiss |   0.4026   0.0967   1.0000
 bfi_z_wmiss |   0.5585   0.0820   0.5480   1.0000
      female |   0.1446   0.2100   0.1511   0.1202   1.0000
         age |  -0.2304  -0.1459  -0.1173  -0.1877  -0.3648   1.0000
years_served |  -0.2379  -0.1369  -0.1571  -0.1699  -0.0880   0.7571   1.0000
      rank_m |  -0.1264  -0.1242  -0.0646  -0.0142  -0.2048   0.7245   0.6917
       educ1 |   0.0439  -0.0001  -0.0385   0.0073  -0.0465   0.1984   0.2179
       educ2 |  -0.0602  -0.0232  -0.1357  -0.0561   0.0027  -0.0279  -0.0162
       educ3 |   0.0474   0.0242   0.1551   0.0559   0.0135  -0.0407  -0.0597

             |   rank_m    educ1    educ2    educ3
-------------+------------------------------------
      rank_m |   1.0000
       educ1 |   0.1917   1.0000
       educ2 |   0.0341  -0.2895   1.0000
       educ3 |  -0.1030  -0.0497  -0.9416   1.0000


. 
. // Capture the correlation matrix into a matrix
. matrix corr_matrix = r(C)

. 
. // Set the Excel file to output the results
. putexcel set "Table_A13.xlsx", replace
note: file will be replaced when the first putexcel command is issued.

. 
. // Export the correlation matrix into Excel starting from cell B2 (shifted to t
> he right by one column)
. putexcel B2=matrix(corr_matrix)
file Table_A13.xlsx saved

. 
. // Add the column headers (shifted by one to start from B1)
. putexcel B1=("Public Service Motivation") C1=("Delegation Skills") D1=("Grit") 
> E1=("Big Five Inventory") F1=("Female") G1=("Age") H1=("Years Served") I1=("Ran
> k") J1=("Education Level 1") K1=("Education Level 2") L1=("Education Level 3")
file Table_A13.xlsx saved

. 
. // Add row labels manually (starting in A2)
. local varlist "psm_z_wmiss ds_z_wmiss grit_z_wmiss bfi_z_wmiss female age years
> _served rank_m educ1 educ2 educ3"

. local i = 2

. foreach var of local varlist {
  2.     putexcel A`i' = "`var'"
  3.     local ++i
  4. }
file Table_A13.xlsx saved
file Table_A13.xlsx saved
file Table_A13.xlsx saved
file Table_A13.xlsx saved
file Table_A13.xlsx saved
file Table_A13.xlsx saved
file Table_A13.xlsx saved
file Table_A13.xlsx saved
file Table_A13.xlsx saved
file Table_A13.xlsx saved
file Table_A13.xlsx saved

. 
. // Close the Excel output
. putexcel save

. 
. 
. log close
      name:  <unnamed>
       log:  /Users/nravanilla/Downloads/HRS_JOP2_Replication/1_Code/bureaucrat_q
> uality_logfile.log
  log type:  text
 closed on:   1 Oct 2024, 19:22:28
---------------------------------------------------------------------------------
